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

This article mainly introduces the solution of error code 1130 in mysql, which can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

Mysql error code 1130 solution: first log in to mysql; and then find the "host" option in the "user" table in the mysql database; finally, change from "localhost" to "%".

Solution to error code 1130 in mysql:

Error description:

Error code: 1130

Host *. * is not allowed to connect to this MySQL server

Solution:

1. Table change method:

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!

2. Authorization Law:

For example, if you want root to connect to the mysql server from any host using root.

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

If you want to allow the user root to connect to the mysql server from the host with ip 192.168.1.3, and use root as the password

GRANT ALL PRIVILEGES ON *. * TO 'root'@'192.168.1.3' IDENTIFIED BY' root' WITH GRANT OPTION; thank you for reading this article carefully. I hope it will be helpful for everyone to share the solution of error code 1130 in mysql. At the same time, I also hope you can support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are 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.