January 26, 2005

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
Comments

free chat rooms - http://www.fooadultchat.com/

Posted by: free chat rooms at December 4, 2006 12:30 AM
Post a comment









Remember personal info?