Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to do 1251 error in navicat connection mysql8, which has certain reference value. Interested friends can refer to it. I hope you will gain a lot after reading this article. Let Xiaobian take you to understand it together.

Problem Description:

Recently installed mysql8, the following error always occurs when trying to connect using navicat.

2, online search reason is found before mysql8 version of the encryption rule is mysql_native_password, and after mysql8, encryption rule is caching_sha2_password, there are two ways to solve the problem, one is to upgrade navicat driver, one is to mysql user login password encryption rules restored to mysql_native_password. Since it is a cracked version of navicat, it can only be solved by the second method;

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

Then enter the root password that you installed mysql with. After entering, the interface is as follows

Note: If you type mysql -u root -p and cmd indicates that mysql is not an internal or external command, nor is it a runnable program or batch file, it means that you did not add mysql path to PATH after installing mysql. The method has a hint at the end of the article;

4. Then change the encryption method in mysql first, and the instructions are as follows:

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

5, and then change the password, because the encryption rules change, so 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 mysql path to PATH environment variable;

1. Win+r-->services.msc--> right-click mysql services--> 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;

Thank you for reading this article carefully. I hope that Xiaobian's "navicat connection mysql8 1251 error how to do" this article is helpful to everyone. At the same time, I hope that everyone will support more, pay attention to the industry information channel, and more relevant knowledge is 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.