Spare Brain wrote:
"Bill Karwin" <bi**@karwin.com> wrote in message
news:de********@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/...tor/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.