Having to set up a new desktop today, I was following the usual procedure for phpmyadmin:
– Put the phpmyadmin folder in /Library/WebServer/Documents/phpmyadmin
– Added the config folder with permissions: chmod o+w /Library/WebServer/Documents/phpmyadmin/config
– Generated config.inc.php with phpmyadmin setup (localhost/phpmyadmin/setup)
– Moved config.inc.php in the phpmyadmin home folder
Still, when trying to log in the UI with the root username and password I was getting this error: “Cannot log in to the MySQL server”.
After resetting the password for mysql 3 times and re-installing entirely phpmyadmin, I stumbled upon a StackOverflow question where Sepp suggested to change localhost to 127.0.0.1 in the config.inc.php file.
Sometimes solutions are that simple.
My two cents for whoever might have the same issue.