Posted by Bill Karwin on 08/29/05 05:03

Spare Brain wrote:
> Hi,
>
> I am trying to run the MySQL DB on a Linux machine that is part of a home
> LAN (IP=192.168.0.3), while trying to access it from another WinXP machine
> (IP=192.168.0.5). I keep getting the following error:
>
> MySQL Error Number 1130
> #HY000Host '192.168.0.5' is not allowed to this MySQL server

The first thing I would try is to grant access to the given user from
that client IP address:

# mysql -u root mysql
mysql> grant all on test.* to 'username'@'192.168.0.3';

See http://dev.mysql.com/doc/mysql/en/adding-users.html for more
information.

I don't know of any "allow list" mechanism in MySQL, except for the one
with which you can restrict client access to a single IP address (the
"--bind-address=<ip-address>" option of mysqld).

Regards,
Bill K.

[Back to original message]