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;!
I’m getting the same error message, problem is that I’m running on MySQL server 5.0. Could it be that I exported the tables from MySQL server 3 and imported them into MySQL server 5.0?
Comment by Jacques — July 17, 2007 @ 4:03 pm
Hi Jacques,
Most likely… did you just leave the data directory where it was? Did you try the old_passwords option in my.cnf?
Comment by James Holden — July 17, 2007 @ 5:08 pm