Client does not support authentication protocol requested by server
Mar 24, 2006 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.
Naba on Jan 24
me also getting this error while runing database migratin the error is
"Client does not support authentication protocol requested by server; consider upgrading MySQL client."
Can any one help.I am new with ruby on rails and spend a lots of time to overcome this
error please help
Leigh on May 24
Thanks for this little nugget. I found it at the end of a very long and tedious day of getting all the parts of my rails development system to play nicely together and it made it all work!
This is the 'net at its best.
**Leigh