The phpMyAdmin that ships with MAMP Pro is now seriously out of date, so you’ll probably want to upgrade to the latest version. You can do this in a couple of easy steps. Firstly, download and uncompress the latest version of phpMyAdmin. I did it to my Desktop. Then, open up Terminal and enter the MAMP Pro folder and rename (best to rename rather than delete) the current phpMyAdmin.
cd /Library/Application\ Support/MAMP\ Pro/ mv phpMyAdmin phpMyAdminBackup
Next, copy in the new version of phpMyAdmin.
cp /Users/you/Desktop/phpMyAdmin-x.x-all-languages ./phpMyAdmin
Finally, you need to set up the configuration for the new phpMyAdmin.
cd phpMyAdmin cp config.sample.inc.php config.inc.php vim config.inc.php
Change the authentication type and add a username and password entry to the file.
$cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = 'root';
If you’ve changed the MySQL root password on your MAMP Pro, you’ll need to enter the new password instead.
Once done, save the file and you’re done.
Don't have time to check my blog? Get a weekly email with all the new posts. This is my personal blog, so obviously it is 100% spam free.
Tags: mamp, mamp pro, mysql, phpmyadmin, upgrade
This entry was posted on Sunday, December 30th, 2012 at 11:32 am and is filed under Life, Tech. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.