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

This article mainly introduces the navicat connection mysql 1130 error solution, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Deployment of a database using Mysql program, sqlyog connection to the database of non-local Mysql server, it is strange that unable to connect, reported a 1130 error.

ERROR 1130: Host 192.168.3.100 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 logging in to mysql on this machine, change the "host" entry in the "user" table in the "mysql" database from "localhost" to "%".

Mysql-u root-pmysql > 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 the mysql library.

Third sentence: check the host value of the user table in the mysql library (that is, the name of the host / IP that can be accessed by the connection).

Fourth sentence: modify the host value (add the host / IP address with the content of the 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.

Remember that the Mysql service needs to be restarted (make sure the changes are valid), otherwise the results of possible changes will not be reflected.

It is important to note that:

1. All the above commands need to be executed under the cmd command.

two。 You need to change to the deployed directory to execute these commands. Cd x:\ dir

3.MySql commands all end with ";".

4. You need to manually enter the password you need not to copy when you execute the first command, which is the password you need to deploy the program.

Thank you for reading this article carefully. I hope the article "navicat connection mysql 1130 error solution" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.