Skip to content

Instantly share code, notes, and snippets.

@dungmanh88

dungmanh88/Create a mysql account with basic permission

Created October 18, 2016 07:42
Show Gist options
  • Save dungmanh88/839aa04cfac65b5238bc1d19280f5fd3 to your computer and use it in GitHub Desktop.
Save dungmanh88/839aa04cfac65b5238bc1d19280f5fd3 to your computer and use it in GitHub Desktop.
Download ZIP
Create a mysql account with basic permission
Raw
Create a mysql account with basic permission
mysql> grant index, create temporary tables, create view, show view, create routine, alter routine, trigger, delete, insert, select, update, execute on `test`.* to 'user'@'host' identified by 'auth_string';
mysql> flush privileges;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment