Posted by Spare Brain on 08/29/05 05:52

"Bill Karwin" <bill@karwin.com> wrote in message
news:detqd30u1r@enews4.newsguy.com...
> 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.


Thanks!! That seems to work!

I generalized it (based on the URL in your note) to 'grant all privileges on
*.* to 'root'@'192.168.0.%' with grant access;'.

What is surprising to me is that my installation of MySQL on the WinXP is
accessible without any such modifications from other machines (including the
Linux), while the installation on the Linux machine needed this fix. Wonder
why??

Thanks again.
Angus

[Back to original message]