Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "how to solve the problem of remote connection mysql error 1130". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Mysql

If you connect to the Mysql server remotely, the error code is 1130J error 1130: Host xxx.xxx.xxx.xxx is not allowed to connect to this MySQL server

The guess is that the user rights cannot be given to the remote connection.

If you operate the library in this way, it can be solved.

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-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'

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.

This is the end of the content of "how to solve the problem of remote connection mysql error 1130". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.