Solve the problem of Navicat for Mysql connection error 1251 (connection failed)

Because what I wrote before was not detailed enough, I modified and supplemented it this time. However, my previous MySQL version was 8.0 and the current version is 5.7, so the screenshots are a bit strange, but the steps are exactly the same, and I have tried both versions.

Step 1: Open Command Line Client. Look carefully, it is not cmd, but in the mysql directory. You will find that there are two identical ones. In fact, either one will work.

Step 2: Enter the MySQL password and press Enter. This is the password you set when installing MySQL. Just enter the password without the semicolon.

Step 3: Enter ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mysql的密码'; press Enter. Don't miss the semicolon at the end. The mysql password is the password you set when you installed mysql.

Step 4: Enter FLUSH PRIVILEGES; press Enter. Do not miss the semicolon at the end.

Let me demonstrate: My mysql password is 111111

If the word OK appears, no error will be reported.

You can also use this method to change the mysql password. For example, my mysql password is 111111 and I want to change it to 123456

Just change the mysql password to 123456

The above is the detailed content of solving the problem of Navicat for Mysql connection error 1251 (connection failed). For more information about Navicat for Mysql connection error 1251, please pay attention to other related articles on 123WORDPRESS.COM!