MySQL : Client does not support authentication protocol

Posted: พฤษภาคม 22, 2006 in Computers and Internet
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 :

  1. Worawitch พูดว่า:


  2. Ñøø¨¨MøЯ|¯ãñø¥zZ^^ พูดว่า:


  3. Bell พูดว่า:

    – -"

  4. Nuntawat พูดว่า:

    ขอบคุณมากต้าร์ เราได้ใช้เลยที่ต้าร์บอก อิอิ


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

You are commenting using your 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