al Message -
> From: "John Daisley"
> To: "mysql"
> 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
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 d
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
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"
> To: mysql@lists.mysql.com
> Sent: Friday, 3 June, 2011 12:03:56 PM
> Subject: Allowing all users to access a
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 tigh
