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 :
http://dev.mysql.com/doc/refman/5.0/en/old-client.html

Advertisements
ความเห็น
  1. Worawitch พูดว่า:

    ????????????????

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

    ทามไงดีอ่า
    เค้าอ่านม่ะออก
    เซรงอ่า
    -*-
     

  3. Bell พูดว่า:

    SQL
     
    – -"
     
     
     

  4. Nuntawat พูดว่า:

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

ใส่ความเห็น

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