Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to solve the problem of navicat connecting mysql Times error 1251, which has a certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

The solution of navicat connection mysql error 1251

1. The newly installed mysql8 always reports an error when using the cracked version of navicat to connect, as shown in the figure:

2. The reason for online search is that in the previous version of mysql8, the encryption rule was mysql_native_password, while after mysql8, the encryption rule was caching_sha2_password.

There are two ways to solve the problem, one is to upgrade the navicat driver, and the other is to restore the mysql user login password encryption rules to mysql_native_password. Since the cracked version of navicat is used, it can only be solved in the second way.

3. First run cmd as an administrator, and then use the command to enter mysql.

Then enter the root password that you set to install mysql to enter. The interface after entering is as follows:

Note: if you type mysql-u root-p, cmd prompts mysql is not an internal or external command, nor is it a runnable program or batch file, you did not add the path of mysql in the environment variable PATH after you installed mysql. This method has a hint at the end of the article.

4. Then change the encryption method in mysql with the following instructions:

ALTER USER 'root'@'localhost' IDENTIFIED BY' password' PASSWORD EXPIRE NEVER

5. Then change the password. Due to the change of encryption rules, you need to reset the password.

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' New password

6. finally, refresh the database.

FLUSH PRIVILEGES

Finally, write how to add the path to mysql in the environment variable PATH

1. Win+r-- > services.msc-- > right-click mysql service-- > Properties-- > find the executable path and copy it

2. Right-click "my computer"-- > Properties-- > Advanced system Settings-- > Environment variables-- > system variables-- > PATH-- > Edit-- > New-- > "executable path" above, as shown in the figure:

Thank you for reading this article carefully. I hope it will be helpful for everyone to share how to solve the problem of how to connect navicat to mysql Times error 1251. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.