Search code examples
phpmysqlphpmyadminmamp

Error "Could not connect to MySQLserver" in phpMyAdmin

Every time I start MAMP and open the start page I get error can't connect to mysql. I'm not sure what I've done but I think I've reset the password and have now forgotten what I changed it too!

I've tried to change it in terminal however I just get: Access denied for user 'root'@'localhost' (using password: YES)

How can I fix this?

I have thought about just doing a new install on MAMP however I have a number of sites in my htdocs and don't want to lose them.

Here is the error I get:

enter image description here

Solution

  • Why don't you change the Mysql Root Password in MAMP ?

    Open MAMP => Server => Mysql => Change the root password (assuming you've MAMP PRO 2.1.1)

    You won't leave your websites if you copy the htdocs directory located under :

    /Applications/MAMP/htdocs (Assuming you're under OS X)