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

Editor to share with you the solution to navicat connection error 1251, I believe most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!

Step 1: open Command Line Client to see clearly that it is not cmd, but in the directory of mysql, you will find that there are two exactly the same, either will do.

Step 2: enter the mysql password. Enter the password you set when you install mysql. Just enter the password without a semicolon.

Step 3: enter the password of ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' mysql'; enter do not miss a semicolon mysql after the password is the password set when installing mysql

Step 4: enter FLUSH PRIVILEGES; enter and don't miss the semicolon

Let me demonstrate: my mysql password is 111111

If the word "OK" appears, it will not be wrong.

The above is all the contents of this article entitled "solution to navicat connection error 1251". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more 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.