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

Xiaobian to share with you what navicat appears 1130 refers to, I hope you read this article after the harvest, let us discuss it together!

When using Navicat to connect to a remote MySQL database, sometimes a "Navicat for mysql 1130 error" appears, indicating that the error content is not allowed to connect to MySQL services. Many people think that the firewall is at fault, in fact, turn off the firewall still can not solve this problem.

Problem Description:

Error No.1130 Host '192.168.25.3' is not allowed to connect to this MySQL server

Cause analysis:

MySQL has only one root user. After changing the root password, select MD5. After submitting, log in again and the error prompt "Host 'localhost' is not allowed to connect to this MySQL server" will appear.

Solution:

1. table modification

Maybe your account does not allow remote login, only localhost. At this time, as long as you log in MySQL on the computer of localhost, change the "host" item in the "user" table of the "MySQL" database, and change "localhost" to "%"

mysql -u root -pvmwaremysql>usemysql;mysql>update user set host = '%' where user ='root';mysql>select host, user from user;

2. authorization act

For example, if myuser uses mysword to connect to mysql server from any host. GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY 'mypassword' WITHGRANT OPTION;

If you want to allow user myuser to connect to mysql servers from hosts with ip 192.168.1.3, use mypassword as password.

GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY'mypassword' WITH GRANT OPTION;

If this doesn't work, add a statement: mysql>FLUSH RIVILEGES to make the change effective. That's it.

3. modify authority law

Run on the machine where MySQL is installed:

d:/mysql/bin/>mysql -h localhost -u root //Enter MySQL Server

mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION //Give any host access to data

mysql>FLUSH PRIVILEGES //Modifications take effect

mysql>EXIT //Exit MySQL Server

This allows you to log in as root on any other host.

After reading this article, I believe you have a certain understanding of what navicat 1130 means. If you want to know more about it, welcome to pay attention to the industry information channel. Thank you for 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.