Skip to content

Instantly share code, notes, and snippets.

@sokratisg
Created June 13, 2014 10:26
Show Gist options
  • Save sokratisg/52042a80a5cafcac29eb to your computer and use it in GitHub Desktop.
Save sokratisg/52042a80a5cafcac29eb to your computer and use it in GitHub Desktop.
MySQL permissions for Backup Admin
CREATE USER 'backupadmin'@'localhost' IDENTIFIED BY '<secret_password>';
GRANT LOCK TABLES, SELECT ON <DB_NAME>.* TO 'backupadmin'@'localhost';
GRANT RELOAD ON *.* TO 'backupadmin'@'localhost';
GRANT CREATE, INSERT, DROP ON mysql.ibbackup_binlog_marker TO 'backupadmin'@'localhost';
GRANT CREATE, INSERT, DROP ON mysql.backup_progress TO 'backupadmin'@'localhost';
GRANT CREATE, INSERT, SELECT, DROP ON mysql.backup_history TO 'backupadmin'@'localhost';
GRANT REPLICATION CLIENT ON *.* TO 'backupadmin'@'localhost';
GRANT SUPER ON *.* TO 'backupadmin'@'localhost';
GRANT CREATE TEMPORARY TABLES ON mysql.* TO 'backupadmin'@'localhost';
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment