my weblog

If you attempt to connect to a MySQL 4.1.x server from a MySQL 4.0.x client you may receive the following error:

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

To fix the problem, first make sure that you have no usernames that are longer than 16 characters:

SELECT Host, User, Password FROM mysql.user WHERE LENGTH(Password) > 16

Now you may update the password for the user to the old style passwords:

SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('newpasswd');

For more information see: Password Hashing in MySQL 4.1

This entry was posted on Thursday, March 3rd, 2005 at 2:16 pm and is filed under General. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.