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
