Solve the 1251 error when establishing a connection between mysql and navicat

I reinstalled the computer and installed the latest version of MySQL database. As a result, Navicat reported error 1251 when connecting to Mysql, and sqlyog reported error 2058. However, when I entered MySQL with the window command, the account and password were correct.

I checked online and found that the reason for this is that the encryption rule in versions before mysql8 is mysql_native_password, while after mysql8, the encryption rule is caching_sha2_password.

There are two ways to solve the problem. One is to upgrade the navicat driver; the other is to restore the mysql user login password encryption rule to mysql_native_password.

I often use the second method:

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 see many people just copy the command directly, which is wrong.

• 'root' is your own username
• 'localhost' refers to the IP opened by the user. It can be 'localhost' (accessible only by this local machine, equivalent to 127.0.0.1), it can be a specific '*.*.*.*' (a specific IP), or '%' (accessible by all IPs)
• 'password' is the user password you wish to use

So, the problem is solved.

The above is the detailed content on how to solve the 1251 error when establishing a connection between MySQL and Navicat. For more information, please pay attention to other related articles on 123WORDPRESS.COM!