MySQL : Client does not support authentication protocol

Client does not support authentication protocol

Password hashing algorithm

MySQL 5.0 uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older (pre-4.1) clients. If you upgrade the server from 4.1, attempts to connect to it with an older client may fail

To solve this problem
Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the "set password" statement and the "old_password()" function:

mysql> set password for some_user‘@’some_host = old_password(‘newpwd‘);

Alternatively, use "update" and "flush privileges":

mysql> update mysql.user set Password = old_password(‘newpwd‘) where Host = ‘some_host‘ and User = ‘some_user‘;
mysql> flush privileges;

Reference :
http://dev.mysql.com/doc/refman/5.0/en/old-client.html

Advertisements

4 thoughts on “MySQL : Client does not support authentication protocol

ใส่ความเห็น

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / เปลี่ยนแปลง )

Twitter picture

You are commenting using your Twitter account. Log Out / เปลี่ยนแปลง )

Facebook photo

You are commenting using your Facebook account. Log Out / เปลี่ยนแปลง )

Google+ photo

You are commenting using your Google+ account. Log Out / เปลี่ยนแปลง )

Connecting to %s