iTank ideas

Como crear un usuario en mySQL 8 con privilegios de backup

jmarior   

Para hacer backups automatizados de las bases de datos, resulta imprescindible crear un usuario con privilegios de backup sobre las bases de datos existentes y las nuevas.

CREATE USER 'mysqlbackup'@'localhost' IDENTIFIED BY 'unPasswordSuperSecreto';
GRANT SELECT ON *.* TO 'mysqlbackup'@'localhost'; # For release 8.0.19 and later
GRANT BACKUP_ADMIN ON *.* TO 'mysqlbackup'@'localhost'; # For release 8.0.16 and later
GRANT SELECT ON performance_schema.variables_info TO 'mysqlbackup'@'localhost'; # For release 8.0.16 to 8.0.18
GRANT SELECT ON performance_schema.log_status TO 'mysqlbackup'@'localhost'; # For release 8.0.16 to 8.0.18
GRANT RELOAD ON *.* TO 'mysqlbackup'@'localhost';
GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO 'mysqlbackup'@'localhost';
GRANT CREATE, INSERT, DROP, UPDATE, SELECT, ALTER ON mysql.backup_history TO 'mysqlbackup'@'localhost';
GRANT REPLICATION CLIENT ON *.* TO 'mysqlbackup'@'localhost';
GRANT SUPER ON *.* TO 'mysqlbackup'@'localhost';
GRANT PROCESS ON *.* TO 'mysqlbackup'@'localhost';
GRANT SELECT ON performance_schema.replication_group_members TO 'mysqlbackup'@'localhost'; # For release 8.0.12 to 8.0.18
GRANT LOCK TABLES, SELECT, CREATE, DROP, FILE ON *.* TO 'mysqlbackup'@'localhost';

Vía mySQL.com

Similar Posts