Category: notes

  • OSX 10.8.2 localhost directory & MySql / PHPMyAdmin

    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!