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

This article mainly introduces the solution to the 1251 error in navicat, which is very detailed and has a certain reference value. Friends who are interested must finish it!

Navicat always reports an error 1251 when connecting to MySQL8.0 and above. The reason is that the encryption method of MySQL8.0 version is different from that of MySQL5.0, and the connection will report an error. The solution:

1. Enter the root account of mysql through the command line:

PS C:\ Windows\ system32 > mysql-uroot-p

Then enter the password for root:

Enter password: * Welcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connection id is 18Server version: 8.0.11 MySQL Community Server-GPLCopyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.mysql >

2. Change the encryption method:

Mysql > ALTER USER 'root'@'localhost' IDENTIFIED BY' password' PASSWORD EXPIRE NEVER;Query OK, 0 rows affected (0.10 sec)

3. Change the password: 123 is the new password in this example

Mysql > ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' 123 query OK, 0 rows affected (0.35 sec)

4. Refresh:

Mysql > FLUSH PRIVILEGES;Query OK, 0 rows affected (0.28 sec)

/ / if an error is reported, ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'%':

The remote access permission is incorrect. Select the database first, check it, and then change it:

Mysql > use mysql;Database changedmysql > select user,host from user +-+-+ | user | host | +-+-+ | mysql.infoschema | localhost | | mysql.session | localhost | mysql.sys | localhost | | root | localhost | +- -+-+ 5 rows in set (0.00 sec)

Finally, restart the MySQL service and reconnect.

The above is all the contents of this article entitled "Solutions to 1251 errors in 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.