Unable to connect to newer mysql database – Client Does Not Support Authentication Protocol Requested By Server, Consider Upgrading MySQL Client

Posted by Paul Farrow - Under: Mini-ITX, Software

Kept getting the message ‘Client Does Not Support Authentication Protocol Requested By Server, Consider Upgrading MySQL Client’ after upgrading the mysql server to a newer version than the client odbc driver and after much trawling found that you have to update the mysql user table to hold the password in the old format like so..

UPDATE mysql.user
SET password=OLD_PASSWORD(‘somepassword’)
WHERE user=’someuser’
AND host=’somehost’;

dont forget to update each host and then reload your privaleges, should then work.

🙂