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
The reason
*GRANT SELECT, INSERT, UPDATE, DELETE ON mydyb TO '%'@'%';*
*
*
does not work is because that command would be suicidal in terms of
security.
If you are hosting a large number of ecommerce sites and granting any user
access to those databases then you would want security to be far
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
On 03/06/2011 11:24, John Daisley wrote:
The reason
*GRANT SELECT, INSERT, UPDATE, DELETE ON mydyb TO '%'@'%';*
*
*
does not work is because that command would be suicidal in terms of
security.
If you are hosting a large number of ecommerce sites and granting any user
access to those databases
You could easily write a script which queries the mysql grant tables and
grants the required permissions to every user on your system. Granting
access the way you were suggesting gives the whole world access not just
users of the system.
That said as that is a shared database which all users are
daisleyj...@googlemail.com
To: mysql mysql@lists.mysql.com
Sent: Friday, 3 June, 2011 1:32:35 PM
Subject: Re: Allowing all users to access a specified database
You could easily write a script which queries the mysql grant tables
and
grants the required permissions to every user on your