An error occurs when using PHPMYADMIN:
Client does not support authentication protocol requested
by 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 encounter the above problems after upgrading mysql to version 4.1 or above, please first make sure your mysql client is version 4.1 or above. (WINDOWS If there is a problem below, you can jump directly to the solution below, because MYSQL is installed on both the client and the server in WINDOWS)
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;