MySQL privileges shortcut

Gervase Markham gerv at mozilla.org
Thu May 19 12:02:55 UTC 2011


Fed up of having to go and do MySQL permissions every time you install a
new test Bugzilla?

Try this:

GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, LOCK TABLES,
CREATE TEMPORARY TABLES, DROP, REFERENCES ON `bugs%`.* TO bugs at localhost
IDENTIFIED BY 'supersekrit';

That will grant the necessary privileges to the "bugs" user to any
database whose name begins with the letters "bugs".

Gerv
_______________________________________________
dev-apps-bugzilla mailing list
dev-apps-bugzilla at lists.mozilla.org
https://lists.mozilla.org/listinfo/dev-apps-bugzilla



More information about the developers mailing list