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
