Installing phpMyAdmin for MySQL Administration

Download latest phpMyAdmin.
In an appropriate website content folder (e.g. /Library/WebServer/Documents/ on Mac OS X):

tar xvf ~/phpMyAdmin-2.11.8.1-english.tar.bz2
ln -s phpMyAdmin-2.11.8.1-english phpmyadmin
cd phpmyadmin
cp config.sample.inc.php config.inc.php

Edit config.inc.php and set your blowfish secret to a random string:

$cfg['blowfish_secret'] = 'ertyrtfghrty';

On Mac OS X Leopard, there appears to be an issue with PHP that you have to resolve by changing localhost to 127.0.0.1:

$cfg['Servers'][$i]['host'] = '127.0.0.1';

Save the file, then browse to http://localhost/phpmyadmin, login as root as see how things look.

You must be logged in to post a comment.