MySQL Administratorでネットワーク上のMySQLを操作する場合

Spare Brain 
Guest
n/a Posts  August 29th, 2005
02:35 AM 
#1  


Error 1130 when accessing MySQL from another IP?? 





























































































































































-














































































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 
Guest
n/a Posts  August 29th, 2005
03:25 AM 
#2  


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





























































































































































-














































































Spare Brain wrote:[color=blue]
> 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[/color]

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.































































































































































-

実際には

c:\mysql\bin>mysql -u root mysql
mysql> grant all on * to 'ideg'@'192.168.1.2';