Installing and Configuring phpMyAdminInstallationAfter downloading phpMyAdmin, the downloaded ZIP can be extracted into your hosting 'http' folder.For example, if using the built in 'personal web sharing' web server, your profile http folder starts here... Macintosh HD/Users/your_user_name/Sites/ Extract the ZIP contents into this folder, and then rename the created folder to 'phpmyadmin' (for example). So it looks like this...Macintosh HD/Users/your_user_name/Sites/phpmyadmin/ ConfigurationUsing Finder, find the following folder:Macintosh HD/Users/your_user_name/Sites/phpmyadmin/ Rename 'config.sample.inc.php' to 'config.inc.php'.Edit the file using a text editor. Look for the following code, on around line 18: $cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
Add some text between the quotes, as shown below:
$cfg['blowfish_secret'] = 'my_blowfish_secret'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
Save the file.
Using your web browser, enter the following into the address bar (without the quotes): 'http://localhost/~your_user_name/phpmyadmin/'. When asked for a username and password, you can use the authentication details as previously noted down from installing mySQL; username being 'root', and the password you have set. You are now able to manage the database directly. ImportantThe set-up shown here is NOT recommended for a live web server. Please read the installation notes for more information on securing phpMyAdmin in a live environment. |
| Comments, Feedback, Suggestions and Documentation Submissions please post in the Documentation Chat Forum. |