Sunday, December 26, 2010

ERROR 1251: Client does not support authentication protocol

Problem Statement:

I got the below error while trying to accessing the upgraded mysqld server with a old client.

Error :

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

Solution :

I have resolved the above my updating the password as below.

update user set password=old_password(’new_password’) where user=’user_name’ and host=’10.0.0.2′;

flush privileges;

and then try to access the mysqld server and now you will be able to connect to the server succesfully.

No comments:

Post a Comment