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

The purpose of this article is to share with you the solution to the 1251 error in navicat connection mysql display. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Reinstalled the computer, installed the latest version of the MySQL database, the result Navicat connection Mysql reported 1251 error, sql reported another 2058 error, but the window command to enter mysql, the account password is correct.

What is found on the Internet is that the encryption rule in the previous version of mysql8 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.

What I often use is the second way:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' password'; # modify encryption rules ALTER USER 'root'@'localhost' IDENTIFIED BY' password' PASSWORD EXPIRE NEVER; # update the user's password FLUSH PRIVILEGES; # refresh permissions

I think many people take orders to copy directly, which is wrong.

The user name defined by root' for yourself

"localhost'" refers to the user's open IP, which can be 'localhost' (local access only, equivalent to 127.0.0.1), specific' *. *'(specific IP), or'%'(all IP can be accessed)

Password' is the user password you want to use

Thank you for reading! This is the end of this article on "navicat connection mysql display 1251 error solution". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

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.