mysql4.1 client does not support authentication protocol problem resolution when connecting over version
shell> MySQL
Client does not support authentication protocol requested
by server; Consider upgrading MySQL client
The official argument is that
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 experience the above issues after upgrading MySQL to 4.1 or above, make sure your MySQL client is 4.1 or higher. (If there is a problem with windows, you just jump to the solution, because MySQL is installed on Windows with the client and server)
Please use one of the following two methods
One
Mysql> SET PASSWORD for
' Some_user ' @ ' some_host ' = Old_password (' newpwd ');
Second:
mysql> UPDATE mysql.user SET Password = Old_password (' newpwd ')
-WHERE Host = ' some_host ' and User = ' some_user ';
mysql> FLUSH privileges;
The red part above please amend according to your actual situation ....
When you do this, the connection will be normal @!
The above describes the mysql41 version of the connection when the client does not the support authentication protocol problem resolution, including the content, I hope to be interested in PHP tutorial friends helpful.
