|
|
Posted by John Kloosterman on 08/29/05 12:09
Spare Brain wrote:
> "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
>
>
Because Linux is more orientated on securty then windows is?
By the way - i dont know if you are running a windowsmanager on the
Linux machine, but there is a very nice free GUI MySQL administrator
utility available for both windows and Linux. Take a look here:
http://www.mysql.com/products/tools/administrator/index.html
Its makes setting rights, creating and mantaining users, databases etc.
as easy as a few mouse-klicks. It can take a lot of pain out of all
these tasks for newcomers, tough i admit its very usefull to learn to
manage all these things from the commandline too... ;-)
John.
Navigation:
[Reply to this message]
|