Error 1130 when accessing MySQL from another IP??

[Spare Brain]

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

Ping works fine.

On searching the internet, I find reference to "allow list" hidden somewhere
in the guts of MySQL. Can anyone provide me hints on how to add to this
list?

Thanks!
SB

[Bill Karwin]

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.

[Spare Brain]

"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

[s a n j a y]

As linux is more security minded, you have to change the mysql config
file. try this

http://linux-discovery.blogspot.com/...m-outside.html

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

Ping works fine.

On searching the internet, I find reference to "allow list" hidden somewhere
in the guts of MySQL. Can anyone provide me hints on how to add to this
list?

Thanks!
SB

[John Kloosterman]

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.