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

This article mainly introduces "how to solve mysql remote link error ERROR 1130". In daily operation, I believe many people have doubts about how to solve mysql remote link error ERROR 1130. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer "how to solve mysql remote link error ERROR 1130". Next, please follow the editor to study!

This error occurs when connecting to mysql with MySQL-Front

ERROR 1130: Host 129.2.1.100 is not allowed to connect to this MySQL server

one. Change the meter. It may be that your account is not allowed to log in remotely, only in localhost. At this time, as long as on the computer in localhost, after logging in to mysql, change the "host" entry in the "user" table in the "mysql" database from "localhost" to "%"

Mysql-u root-p

Mysql > use mysql

Mysql > update user set host ='% 'where user =' root'

Mysql > flush privileges

Mysql > select 'host','user' from user where user='root'

You can connect now!

two。 Authorization law. For example, if you want myuser to connect to the mysql server from any host using mypassword.

GRANT ALL PRIVILEGES ON *. * TO'myuser'@'%'IDENTIFIED BY 'mypassword' WITH GRANT OPTION

If you want to allow the user myuser to connect to the mysql server from the host with ip 129.2.1.22, and use mypassword as the password

GRANT ALL PRIVILEGES ON *. * TO'myuser'@'129.2.1.22'IDENTIFIED BY 'mypassword' WITH

At this point, the study on "how to solve the mysql remote link error ERROR 1130" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.