Client does not support authentication protocol requested by server

Mar 24 by Andre
So I upgraded my local MySql server installation from 4.1 to 5.0. When I tried to generate scaffolds with Rails, I got a Client does not support authentication protocol requested by server; consider upgrading MySQL client.

If you run into this the answer is http://dev.mysql.com/doc/refman/5.0/en/old-client.html

In a nutshell, you have to run SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

Happy upgrading, MySQL users.

Comments

1

Mark on Jun 25

Thanks for posting this. I encountered the same problem and your post (found via a Yahoo search) saved me from having to look further.

Post a comment

 
This is so filters can reject the spam-bots. Thanks!