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" <m...@good-stuff.co.uk> > To: mysql@lists.mysql.com > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org