You are here
Privileges of MySQL backup user for mysqldump
Tue, 2012-12-11 21:34 — Shinguz
Some MySQL customers do not want to use the root
user for mysqldump
backups. For this user you have to grant the following minimal MySQL privileges:
mysqldump --single-transaction
(InnoDB)
CREATE USER 'backup'@'localhost' IDENTIFIED BY 'secret'; GRANT SELECT, SHOW VIEW, RELOAD, REPLICATION CLIENT, EVENT, TRIGGER ON *.* TO 'backup'@'localhost';
mysqldump --lock-all-tables
(MyISAM)
GRANT LOCK TABLES ON *.* TO 'backup'@'localhost';
If we missed a privilege please let us know.
- Shinguz's blog
- Log in or register to post comments