Skip to content

Instantly share code, notes, and snippets.

@bmvakili

bmvakili/mysql-command-create-user-backup

Created May 21, 2014 22:23
Show Gist options
  • Save bmvakili/dd2cb13d5a2414e4206d to your computer and use it in GitHub Desktop.
Save bmvakili/dd2cb13d5a2414e4206d to your computer and use it in GitHub Desktop.
Download ZIP
Mysql grant read-only for backup
Raw
mysql-command-create-user-backup
grant select, lock tables on *.* to 'backup'@'localhost' identified by 'backup';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment