Problems encountered during installation of MySQL and phpMyAdmin [1251-client does yadmin tried to connect

1. After phpMyAdmin is installed

PhpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. you shoshould check the host, username and password in config. inc. PHP and make sure that they correspond to the information given by the administrator of the MySQL server.

Modify config. ini. php to modify the sock path.

Set the user name and password as follows. ini. about 75 rows in PHP $ cfg ['servers'] [$ I] ['auth _ type'] = 'cooker '; // This is also important. The default value is "Config" $ cfg ['servers'] [$ I] ['user'] = 'root '; $ cfg ['servers'] [$ I] ['Password'] = '000000'; 2. after that, there will be a #1251-client does not support Authentication Protocol requested by server; consider upgrading MYSQL client

This problem occurs only in MySQL 4.1.x and later versions. If you use 4.0.x, it will be okay.

The reason is that the new password verification mechanism is used in the MySQL server version you are using. This requires the client version to be later than 4.0. The original password function is changed to old_password ();, in this way, it is difficult to use the password () generated by the client in the old version, while the mysql client in PHP is 3.23 (except for mysqli extension ), this is the problem.

Currently known solutions:

(1) Go to the command line, go to the bin directory of the MySQL directory, and enter the MySQL Command Line Mode:
Example: D:/MySQL/bin> mysql-uroot-p123 (User Root, password 123)
(2) enter the following command:

MySQL > Set Password For   ' Root ' @ ' Localhost ' = Old_password ( ' 123 ' ); (Note that there must be no fewer colons)

(3) return to the MySQL command line:

MySQL > Q

3. Another problem is that the installation of MySQL is unsuccessful, but the start service is started at the end of the installation process (X)

Solution:

You have installed the MySQL service before. You are shutting down the firewall, deleting the residual records of the previous installation, and then reinstalling the service. During the steps of "Install as Windows service, the default "service name" is (MySQL). In the drop-down box, select another
Don't use the name you used before.

I encountered these problems when I was in the security department. I hope to help you and discuss them together!