Skip to content

Instantly share code, notes, and snippets.

@tomzx

tomzx/gist:9354214

Created March 4, 2014 19:51
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tomzx/9354214 to your computer and use it in GitHub Desktop.
Save tomzx/9354214 to your computer and use it in GitHub Desktop.
Download ZIP
Give ALL permissions to NAME_dev on %_dev databases
Raw
gistfile1.txt
GRANT CREATE ROUTINE, CREATE VIEW, ALTER, SHOW VIEW, CREATE, ALTER ROUTINE, EVENT, INSERT, SELECT, DELETE, TRIGGER, GRANT OPTION, REFERENCES, UPDATE, DROP, EXECUTE, LOCK TABLES, CREATE TEMPORARY TABLES, INDEX ON `%\_dev`.* TO 'NAME_dev'@'localhost';
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment