PRIVILEGES OF MYSQL BACKUP USER FOR MYSQLDUMP

on November 10th, 2016 by Hades | No Comments »

Please do not use the root user for mysqldump backups. Just create a new user with the following minimal MySQL privileges:

MYSQLDUMP –SINGLE-TRANSACTION (INNODB)

MYSQLDUMP –LOCK-ALL-TABLES (MYISAM)