Source: http://dev.mysql.com/doc/mysql/en/Old_client.html
MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that's incompatible with that used by older clients. If you upgrade the server to 4.1, attempts-to-connect to it with a older client may fail with the following Message:shel L> Mysqlclient does not support authentication protocol Requestedby server; Consider upgrading MySQL client
To solve this problem, you should use one of the following Approaches:upgrade all client programs to use a 4.1.1 or newer Client library. When connecting-to-the-server with a pre-4.1 client program, the use of the account is still has a pre-4.1-style password. Reset the password to pre-4.1 style for each user, needs to use a pre-4.1 client program. This can is done using the SET PASSWORD statement and the Old_password () function:mysql> SET PASSWORD for-Some_u Ser@some_host = Old_password (NEWPWD); Alternatively, use Update and FLUSH privileges:mysql> update mysql.user SET Password = Old_password (newpwd), wher E Host = some_host and User = some_user;mysql> FLUSH privileges; Substitute the password you want to use for "newpwd in the preceding examples. MySQL cannot tell the original password is, so youll need to pick a new one. Tell the server to use the older password hashing Algorithm:start mysqld with the--old-passwords option. Assign an Old-format passworThe had its password updated to the longer 4.1 format. You can identify these accounts and the following query:mysql> SELECT Host, User, Password from Mysql.user wher E LENGTH (Password) > 16; For each account record displayed by the query, use the Host and User values and assign a password using the Old_password ( function and either SET PASSWORD or UPDATE, as described earlier.
For additional background on password hashing and authentication, see sections 5.5.9 password hashing in MySQL 4.1.
Source: http://dev.mysql.com/doc/mysql/en/Old_client.html
http://www.bkjia.com/PHPjc/531877.html www.bkjia.com true http://www.bkjia.com/PHPjc/531877.html techarticle Source: http://dev.mysql.com/doc/mysql/en/Old_client.html MySQL 4.1 and up uses the authentication protocol based on a pass Word hashing algorithm that's incompatible with the that used ...
