after some upgrades, phpMyAdmin will no longer log in;
#2000 Cannot log in to the MySQL Server
to fix this I had to update the passwords to the longer version
UPDATE user set Password = PASSWORD(‘my_password’) where User=’root’ and Host=’127.0.0.1′;
and make sure to have “old_passwords=1” in my.cnf
restart mysql: /etc/init.d/mysqld restart
2 Responses to phpMyAdmin Error #2000 Cannot log in to the MySQL Server