GRANT with database name wildcard in MySQL?
- by JR Lawhorne
I want to create a user 'projectA' that has the same permissions to every database named 'projectA_%'
I know its possible but MySQL doesn't like my syntax:
grant all on 'projectA_%'.* to 'projectA'@'%';
Reference: http://dev.mysql.com/doc/refman/5.1/en/grant.html