List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 28 2003 10:37pm
Subject:Re: How to use GRANT for Network Client?(for newbie)
View as plain text  
At 18:15 +0000 3/28/03, Terrance Win wrote:
>Hello Everybody,
>         I have a MySQL server in my W2K server DNS=Network.srv. 
>User name 'Admin' and password ='password' is for Admin purpose in 
>Server.
>Database name = 'TestDB'
>IP for server      = 192.168.111.2
>
>        So I set up grant
>GRANT ALL on TestDB.* TO Admin@stripped IDENTIFIED BY 'password';
>
>It works pretty well on server machine.
>
>    I've another machine with IP = 192.168.111.3.
>
>Do I need to set a grant such as
>GRANT ALL on TestDB.* TO Admin@stripped IDENTIFIED BY 'password';

The GRANT statement specifies the host *from which* the client is
connecting, not the host *to which* the client connects -- assuming
that they're different.

So, in your situation, it appears that you do need the second GRANT
statement.

>Thank you.
>Terry


-- 
Paul DuBois
http://www.kitebird.com/
sql, query
Thread
How to use GRANT for Network Client?(for newbie)Terrance Win28 Mar
  • Re: How to use GRANT for Network Client?(for newbie)Paul DuBois28 Mar