MySQL Authentication Problems
Once again, another one of those posts for my future self!
If you’re getting:
Client does not support authentication protocol requested by server; consider upgrading MySQL client
…after upgrading to MySQL 4.1+, it’s because your client application doesn’t support the new password hashes.
The solution is to do the following:
SET PASSWORD FOR 'theuser'@'thehost' = OLD_PASSWORD('thepassword');
For a more permanent solution set add old_passwords in the [mysqld] section of the my.cnf file. This will keep any future password changes in the older format.
As always, don’t forget to do a flush privileges;!
