You know, just because it will bug me again at some point:
If for any reason you don’t want to use the “sites” folder for your web development, you can head to
/Library/WebServer/Documents
and upload code directly into your http://localhost folder.
to install PHPMyAdmin, just plop that PHPMyAdmin folder just downloaded right into the above folder.
To Install MySQL however, follow these steps:
Download the .dmg MySQL installed from MySQL.com
Run the first installed, then the auto-start installer, and finally the Preference Pane add-on.
Run this code in terminal:
sudo cp /etc/php.ini.default /etc/php.ini
and then load /etc/php.ini and replace any instance of
/var/mysql/mysql.sock
with
/tmp/mysql.sock
Start the MySQL server using the preference pane add-on, then run the following in Terminal:
/usr/local/mysql/bin/mysqladmin -u root password PASSWORD
Replacing PASSWORD with a password of your choice.
The last thing to do is head to the PHPMyAdmin directory, and copy the config.sample.inc.php to config.inc.php and edit that file, replacing the
$cfg['blowfish_secret'] = 'RANDOM BLOWFISH CHARACTERS'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
RANDOM BLOWFISH CHARACTERS part with random characters!
Finally, head to http://localhost/phpmyadmin and your good to go!