Why do I get “MySQL error 1130 – Host is not allowed to connect” error?
Receiving ‘MySQL error 1130’? We can help you in fixing it.
Normally, the error code 1130 pops up when trying to access the MySQL servers.
At Bobcares, we receive requests to fix the MySQL errors as a part of our Server Management Services.
Today, let’s know the causes of this error and see how our Support Engineers fix it in MYSQL servers.
Why does MySQL error 1130 occur?
We’ve seen many of our customers experiencing this error message while accessing the MySQL servers.
The error code 1130 normally occurs if there is any networking problem.
Now, let’s go through the main reasons for this error message to appear.
1. If the server is not able to resolve the hostname of the client.
2. In case if the host isn’t allowed to connect to the MySQL server.
The error message appears as:
How we fix MySQL error 1130?
Till now, we discussed the reasons for this error to occur. Now, let’s see how our Support Engineers fix this error for our customers.
Recently, one of our customers approached us with the same error message.
Allow access permission to the IP-Address of the client.
Basically, this means we are allowing permission to specific IP addresses to access the MYSQL server.
For this, we run the below command to grant the permissions to the database.
grant all on db.* to 'username'@'192.168.0.1';
Finally, this fixed the error message.
Allow users from any network.
To allow users from any network, we perform the below steps.
Initially, we access the configuration file which is located in the path /etc/mysql/my.cnf.
Then we comment the below lines within the configuration file
#bind-address = 127.0.0.1 #skip-networking
Then we restart the MySQL server
service mysql restart
Finally, we login to MySQL and change the grant privileges. For that, we run the below command.
GRANT ALL ON *.* to root@'%' IDENTIFIED BY 'root_password';
Also, we ensure that the customers MySQL port 3306 is opened which is the default port of MySQL Database Server.
This resolves the error effectively.
[Need any further assistance with MySQL errors? – We’ll help you]
Today, we saw the causes of the error “Mysql error 1130: Host is not allowed to connect to this MySQL server” and saw how our Support Engineers fix it for our customers.