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

Editor to share with you the solution to the 1251 error of the navicat newspaper. I hope you will gain something after reading this article. Let's discuss it together.

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, but 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 encryption rule of mysql login password 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 following figure:

After reading this article, I believe you have a certain understanding of "the solution to the error of navicat 1251". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

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.