Client does not support authentication protocol MySQL error

[Kevin]

Hi,

You might have seen the error "Client does not support authentication protocol" in your application. This is due to version problem of MySQL.  For example, if you upgrade your server from MySQL 4.0 to MySQL 4.1 then you may face the problem to connect to your MySQL Database. You may receive the below error:

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

To solve this problem, you can follow the below option:

- Go to command prompt of mysql using below command:
mysql -u root -p

- Then shot out the below command:

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

- Now flush the privileges using the below command:

flush privileges;

You are facing this problem because both the versions of MySQL use different format to store password.

Kevin

[scott]

Hi Kevin,

Thanks for sharing it.

Scott