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.
