Skip to content

Instantly share code, notes, and snippets.

@bonelifer

bonelifer/create_mysql_backup_user.sql

Forked from oliworx/create_mysql_backup_user.sql
Created October 2, 2025 19:53
Show Gist options
  • Save bonelifer/e752c6bd8259452b1182eb8d544370de to your computer and use it in GitHub Desktop.
Save bonelifer/e752c6bd8259452b1182eb8d544370de to your computer and use it in GitHub Desktop.
Download ZIP
Create MySQL user to backup databases
Raw
create_mysql_backup_user.sql
CREATE USER 'dbbackup'@'localhost' IDENTIFIED BY '***';
GRANT SELECT ,
RELOAD ,
FILE ,
SUPER ,
LOCK TABLES ,
SHOW VIEW ON * . * TO 'dbbackup'@'localhost' IDENTIFIED BY '***'
WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment