Updating phpMyAdmin on MAMP Pro
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.
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.