MAMP MySQL Cannot connect: invalid settings.
I’ve run into a issue in my MAMP instillation, I didn’t change anything it just happened. I start MAMP perfectly fine and it gives the green light that the MySQL server is up and I can connect to it from the terminal using the mysql command. However when I try and open phpMyAdmin I get this error:
Error MySQL said: Documentation
Cannot connect: invalid settings. phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
I didn’t change the default username and password and have subsequently tried to reset them to root and root which is what phpMyAdmin thinks they are. However I still get this error. The host is still set to localhost. I’ve tried uninstalling and reinstall MAMP to no avail.
Solution
Change these two lines in config.inc.php file.
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['port'] = '8889';
This should solve the problem.
