MySQL privileges shortcut

[Gervase Markham]

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