[FIXED] MySQL and PhpMyAdmin config.inc.php Password issue on MAMP

Issue

This is a very strange issue that is similar to a few other people issue that has been going on for a while with MAMP. I recently upgraded to MAMP2 and followed the instruction for the new phpMyAdmin and it work for a while but recently whenever I try to connect to MySQL I always get this error:

 Error: Could not connect to MySQL server!
 /Applications/MAMP/Library/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

So I changed the password to the correct one and changed all the files as per advised on this forum topic: http://forum.mamp.info/viewtopic.php?f=2&t=11974.

But it did not work at all. I realized that there was two phpMyAdmin folder on my Mac one which is in

 /Applications/MAMP/Library/bin/phpMyAdmin

and the other one in

 Library/Application Support/appsolute/MAMP PRO/phpMyAdmin

In the first folder the config.inc.php as the correct credential for the user, however the second as root for both username and password. Obviously I tried to changed that but to no avail, the file is somehow always reverted to the default credential.

Did someone ever had this issue? is there a way to solve this?

Solution

I forgot to update this, if anyone is interested I got the fix for this (and I know many people had a similar issue). In mamp.pro.global.preferences.plist is listed the encoded MySQLRootPassword, if like me you did update of your MAMP overrite this password field with your old one and there you have it, it works !

Answered By - AKFourSeven