Please Login or Register
Advanced search

083 - MySQL Error 1130 "Host is not allowed to connect ...

Submitted by admin on Wed, 04/22/2009 - 15:20

Error 1130 is a networking error. The server cannot resolve the hostname of the client. Or the host is not allowed to connect to the MySQL server.

First you should check a user in the remort server in order to login, If not there, You have to create a user for remote login.

mysql> use mysql;
mysql> select host, user from user;

There is no your host name, the following command can create user.

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.xx.xx' IDENTIFIED BY 'your_password' WITH GRANT OPTION;

Although you can use the Windows network name as hostname, it may be a network configuration problem.
Try using the IP instead, otherwise you might get the error 1130.

On Unix/Linux systems the hosts files sometimes reads

    127.0.0.1 localhost.localdomain

This causes a problem with MySQL. MySQL docs at http://dev.mysql.com/doc/refman/5.0/en/connection-access.html say:

A Host value may be a hostname or an IP number, or 'localhost' to indicate the local host. No mention of 'localhost.localdomain'.
This means that MySQL can't resolve that 'automatically.