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.
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
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.