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

This article shows you how to solve 1251 errors when establishing a connection between mysql and navicat. The content is concise and easy to understand, which will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

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

The above content is how to solve 1251 errors when establishing a connection between mysql and navicat. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are 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.