Client Does Not Support Authentication Protocol Problem Solutions occurred during mysql4.1 or above
Shell> MySQLClient Does Not Support Authentication Protocol RequestedBy Server; Consider Upgrading MySQL Client
The official statement is
Mysql 4.1 and up Uses An Authentication Protocol Based ON A Password Hashing Algorithm That Is Incompatible with That Used by Older Clients. .....
If you upgrade Mysql to 4.1, you have encountered the above questions, please make sure your MySQL Client is 4.1 or higher. (There is a problem under Windows, you will jump directly to the solution, because MySQL is in Windows is Client. Pooked together with Server)
Please use one of the following two methods
One:
Mysql> Set Password for
-> 'some_user' @ 'Some_host' = Old_Password ('newpwd');
Two:
mysql> update mysql.user set password = Old_password ('newpwd')
-> Where host = 'some_host' and user = 'some_user';
mysql> flush privileges;
In the red part of the above, please modify it according to your actual situation.
After doing this, the connection will be normal.
