Question:
I'm getting the following error connecting to MySQL database:
-
|
Error description: Client does not support authentication protocol
requested by server; consider upgrading MySQL client |
Answer:
To fix this problem you need to run the following in MySQL command line:
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;
More info on this: http://dev.mysql.com/doc/mysql/en/old-client.html
|