Hi, After every modification in mysql.user table you must do: "FLUSH PRIVILEGES;"
Regards, Gelu _____________________________________________________ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] ----- Original Message ----- From: "Ron Parker" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 05, 2002 12:25 PM Subject: Access to Table from any Host on Internet > I'm trying to execute a statement which will allow access to a table by > a user from *any* client on the Internet. I enter something like this: > > GRANT SELECT ON DB.TABLE TO serf@'%' IDENTIFIED BY 'readonly'; > > Yet, I'm unable to access DB.TABLE unless I replace '%' with the > hostname of the client from which I am executing the sql query. The > MySQL documentation seems to say that using '%' will allow access to a > table from any host on the Internet, but my tests don't seem to bear > that out. Am I missing something here? Thanks. > > -ron > > -- > Ron Parker > Software Creations http://www.scbbs.com > Civil War Online Library http://civilwar.scbbs.com > VSB Interest Group http://vsb.scbbs.com > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php