Mysql 4.1 upgrade issues under Windows_PHP tutorial

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 higher. (If there is a problem under WINDOWS, jump directly to the solution below, because MYSQL is installed on both client and server in WINDOWS)

Please Use one of the following two methods

:

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;
(Source: Viphot)

http://www.bkjia.com/PHPjc/314032.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/314032.htmlTechArticleAn 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 authen...