tim's journal

MySQL 4.1+ reports "Client does not support authentication protocol"

Here's a solution. The issue, as you might guess, is that MySQL 4.1+ employs a new authentication protocl. Old clients, including MyODBC 3.51 will report this error. There are a variety of fixes, here's what I used.

Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function:

mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

I had to do it using the root account.

Posted by torque at January 26, 2005 3:09 PM | TrackBack