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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
