While it does not support wildcards, it does support an empty username field. A subtle
distinction :-) Simply grant access to ''@'%'.
----- Original Message -----
> From: "Mark Goodge" <mark@stripped>
> To: mysql@stripped
> Sent: Friday, 3 June, 2011 12:03:56 PM
> Subject: Allowing all users to access a specified database
>
> Hi,
>
> I have a database server with multiple users and multiple databases.
> I
> have a situation where I want to allow any user to connect to a
> specified database.
>
> Unfortunately, the documentation has this to say:
>
> "MySQL does not support wildcards in user names."
>
> Which means, that, although I can use this syntax to grant access for
> a
> user to all databases:
>
> GRANT SELECT, INSERT, UPDATE, DELETE ON * TO 'someuser'@'%';
>
> I can't do something like this to grant all users access to a
> database:
>
> GRANT SELECT, INSERT, UPDATE, DELETE ON mydyb TO '%'@'%';
>
> So, my question is this: How can I allow any user to use a specific
> database, without individually granting them all access?
>
> The reason I want to be able to do this is that the server hosts a
> large
> number of individual ecommerce sites running on the same core
> software.
> Each site has its own database for products, customer data, etc,
> which
> is only accessible to that site. But each site also needs to be able
> to
> access a single, server-wide database which both stores configuration
> information for the software that the sites run on and store usage
> statistics for each site which can be accessed by the server admins
> without needing to have access to each site's own database.
>
> Clues, anyone?
>
> Mark
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
