At 15:29 -0500 10/21/02, Terry & Cheryl Haimann wrote:
I want to give read access to all users on the localhost for a specific mysql table, I have tried the following:
grant select on database.table to %@localhost;
grant select on database.table to "%"@localhost;
grant select on database.table to " "@localhost;
None seem to work, what is the correct format?
There isn't one. Wildcards aren't allowed in the user part of account names.
You could grant access to the anonymous user for the database, perhaps, but the syntax for that is ""@localhost, not " "@localhost. --------------------------------------------------------------------- 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
