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

Editor to share with you the solution to the error of Navicat connection 1130. I hope you will gain a lot after reading this article. Let's discuss it together.

The error code is 1130mm error 1130: Host X.X.X.X is not allowed to connect to this MySQL server

The guess is that the user rights cannot be given to the remote connection. As a result, you can solve the problem by manipulating the mysql library in this way.

After the server logs in to mysql, change the "host" entry in the "user" table in the "mysql" database and rename "localhost" to "%".

Here is how to solve the problem with SQL statements:

Mysql-u root-p mysql;use mysql; mysql;select 'host' from user where user='root'; mysql;update user set host ='% 'where user='root'; mysql;flush privileges; mysql;select' host' from user where user='root'

The first sentence: log in as the authorized user root

Second sentence: select mysql library

The third sentence: check the host value of the user table in the mysql library (that is, the name of the host / IP for connection access)

Fourth sentence: modify the host value (add the host / IP address with wildcard%), of course, you can also directly increase the IP address.

Fifth sentence: refresh the system permission related table of MySQL

The sixth sentence: when you re-look at the user table, there are changes.

Restart the mysql service to complete.

After reading this article, I believe you have a certain understanding of the solution to the error of Navicat connection 1130. If you want to know more about it, welcome to follow the industry information channel. Thank you for your reading!

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.