[TIP] Can't access mysql with phpmyadmin after upgrade

[Nimo]

After upgrading mysql and phpmyadmin I no longer could access my mysql-database with phpmyadmin. I got this error message:

Client does not support authentication protocol requested by server; consider upgrading MySQL client

I've been browsing the gentoo-forums and other sources of information for hours until I finally found the fix. First do:

Code: Select all

$ mysql -u root --password

Then execute this line that solves it all:

Code: Select all

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

Remember to do it for both the pma and root/admin-user. I found this explanation to the problem in the mysql manual:
This problem is generally caused by using MySQL version 4.1 or newer. MySQL changed the authentication hash and your PHP is trying to use the old method.

[Enigma_Man]

Something I just ran into, not quite sure why. I upgraded phpmyadmin, and when trying to access the phpmyadmin page, it complained about not having sessions available. I had to recompile php with the "session" use flag. I don't think I had upgraded php lately, but I'm not the best at paying attention.

Hope it helps someone.

-Jesse

[Peach]

Then execute this line that solves it all:

Code: Select all

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

Remember to do it for both the pma and root/admin-user.

I would add: the pma password to be re-set is found in config.inc.php in the phpmyadmin dir.
Just because I'm dumb.