MySQL client error

Error:

Client does not support authentication protocol requested by server; consider upgrading MySQL client

Fix:

Execute the following commands in MySQL prompt.

UPDATE mysql.user SET Password = OLD_PASSWORD(’new password’) WHERE host = ‘localhost’ AND User = ‘root’;

FLUSH PRIVILEGES;