List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 21 2002 11:22pm
Subject:Re: mysql grant ?
View as plain text  
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.
Thread
mysql grant ?Terry & Cheryl Haimann22 Oct
  • Re: mysql grant ?Paul DuBois22 Oct