Mysql 4 or higher version of the password algorithm results in the "Client Does Not Support Authentication Protocol Request

xiaoxiao2021-03-06  86

I used to use MySQL 3.23.44, and I like to have an early adopters, I can't help but use a few days of php5. I feel that my mysql is too weak, so I upgraded my mysql, my heart, the latest mysql 5.0.1, 嘿嘿, do not believe in weakness.

Installation is smooth, log in to MySQL

G: / mysql / bin> mysql -uroot

mysql> ......

Then remove some unused accounts, leaving only a root account.

Update root password:

MySQL> Update User Set Password = Password ('password') where host = 'localhost' and user = 'root';

success!

Exit and restart the MySQL service.

Next, configuring phpmyadmin's config.inc.php

Modify the mysql username, password

Open phpMyadmin, log in:

The result is unexpectedly popped up error message:

Client Does Not Support Authentication Protocol Requested by Server

It seems that I needed me to upgrade the client, I was completely disappointed, I thought MYSQL 5.0.1 was also as good as 3.23.44.

Later, I was searching for some of the content in the error message using Google search, and I saw the official website of MySQL. I saw it, I understood it. It turned out that the problem of the Password algorithm, because the 5.0.1 mysql Password algorithm and 3.23.44 algorithm are different. In

(Original address: http://dev.mysql.com/doc/mysql/en/old_client.html)

Take the solution to the official website, get it, 嘿嘿

Mysql> Set Password for> 'root' @ 'localhost' = OLD_Password ('newpassword');

Write this article, only friends who have the same problem can solve this problem as soon as possible. There is also a way, you can also solve this problem by upgrading the MySQL client, and the newly introduced MySQLI introduced by PHP5 can. If you use PHP4 to connect MySQL4 or more databases, use this article to solve it. Welcome netizens to exchange experience. QQ: 47974924MSN: fzj_w@yahoo.com.cnemail: fzj-w@126.com

转载请注明原文地址:https://www.9cbs.com/read-122494.html

New Post(0)