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

This article will explain in detail how to deal with the failure of navicat connection to mysql. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

1. Local connection the local database cannot be connected, an error 1251 error code was reported.

Step one, open Command Line Client.

The second step is to enter the mysql password and press the enter key, that is, when you install mysql, you can only enter the password without a semicolon.

The third step is to enter the password of ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' mysql'; press enter and don't miss a semicolon. The password of mysql is the password you set when you installed mysql.

Step 4, type FLUSH PRIVILEGES; and press enter (don't leave out the semicolon).

2. The connection to the database server in the local area network is not successful.

The first step is to open the MySQL server, enter the password, and connect successfully.

Step two, open the database: use mysql.

Retrieve user and host fields: mysql > select user, host from user

If there are no users with user = root, host =%, execute the following statement:

Update user set host='%' where user='root'

The third step is to authorize root (all permissions).

GRANT ALL PRIVILEGES ON *. * TO 'root'@'%' IDENTIFIED BY' 123456 'WITH GRANT OPTION

The fourth step is to let the granted authority take effect immediately.

Flush privileges; on how to deal with navicat connection mysql failure to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.