Error 1130 when accessing MySQL from another IP??

Error 1130 when accessing MySQL from another IP??

am 29.08.2005 03:28:52 von 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

Re: Error 1130 when accessing MySQL from another IP??

am 29.08.2005 04:03:54 von 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=" option of mysqld).

Regards,
Bill K.

Re: Error 1130 when accessing MySQL from another IP??

am 29.08.2005 04:03:54 von 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=" option of mysqld).

Regards,
Bill K.

Re: Error 1130 when accessing MySQL from another IP??

am 29.08.2005 04:03:54 von 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=" option of mysqld).

Regards,
Bill K.

Re: Error 1130 when accessing MySQL from another IP??

am 29.08.2005 04:52:04 von Spare Brain

"Bill Karwin" 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=" 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

Re: Error 1130 when accessing MySQL from another IP??

am 29.08.2005 04:52:04 von Spare Brain

"Bill Karwin" 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=" 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

Re: Error 1130 when accessing MySQL from another IP??

am 29.08.2005 04:52:04 von Spare Brain

"Bill Karwin" 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=" 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

Re: Error 1130 when accessing MySQL from another IP??

am 29.08.2005 08:03:28 von Unicorn

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

http://linux-discovery.blogspot.com/2005/07/mysql-connect-fr om-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
>
>

Re: Error 1130 when accessing MySQL from another IP??

am 29.08.2005 08:03:28 von Unicorn

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

http://linux-discovery.blogspot.com/2005/07/mysql-connect-fr om-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
>
>

Re: Error 1130 when accessing MySQL from another IP??

am 29.08.2005 08:03:28 von Unicorn

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

http://linux-discovery.blogspot.com/2005/07/mysql-connect-fr om-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
>
>

Re: Error 1130 when accessing MySQL from another IP??

am 29.08.2005 11:09:50 von John Kloosterman

Spare Brain wrote:
> "Bill Karwin" 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=" 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.

Re: Error 1130 when accessing MySQL from another IP??

am 29.08.2005 11:09:50 von John Kloosterman

Spare Brain wrote:
> "Bill Karwin" 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=" 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.

Re: Error 1130 when accessing MySQL from another IP??

am 29.08.2005 11:09:50 von John Kloosterman

Spare Brain wrote:
> "Bill Karwin" 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=" 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.