[RESOLVED] mySQL/PHPMyAdmin Upgrades

[obrienkev]

Hi all,

I upgraded PHPMyAdmin and MySQL to latest releases.

However, after setting the new root password in the config.inc.php file PHPMyAdmin gives this error...

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.

Why is this?

Thanks.

[obrienkev]

Hi all,

Found this and it works...

The Fix

This is because, the mysqlclient installed on the box does not use the same authentication protocol that the mysqlserver is using. You can either upgrade the client, or reset the root password using this

SET PASSWORD FOR user@localhost = OLD_PASSWORD('password');