Home > Backend Development > PHP Tutorial > Upgrade issues under Mysql4.1 Windows_PHP tutorial

Upgrade issues under Mysql4.1 Windows_PHP tutorial

WBOY
Release: 2016-07-13 17:22:24
Original
818 people have browsed it

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;

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/532327.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...
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template