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

This article mainly introduces the solution to the 1251 error in establishing a connection between mysql and navicat. The article is very detailed and has a certain reference value. Interested friends must read it!

Reinstalled the computer, installed the latest version of the MySQL database, the result Navicat connection Mysql reported 1251 error, sqlyog reported 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

These are all the contents of this article entitled "the solution to the 1251 error in establishing a connection between mysql and navicat". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.