Solution to the problem that Client does not support authentication protocol appears when connecting to mysql41 or above

Solution to the problem that Client does not support authentication protocol appears when connecting to mysql4.1 or above
shell> mysql
Client does not support authentication protocol requested
by server; considering 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 that your mysql client is version 4.1 or higher. (If there are problems under WINDOWS, you can jump directly to the solution below, because MYSQL is under WINDOWS Client and server are installed together)
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;
Please modify the red part above according to your actual situation....
After doing this, the connection will be normal@!

The above introduces the solution to the problem that Client does not support authentication protocol occurs when connecting to mysql41 or above versions, including the relevant content. I hope it will be helpful to friends who are interested in PHP tutorials.