Permission for a MySQL user to perform Backups

What permissions for a MySQL user would be enough to perform a full backup?

I use innobackupex which requires a password on the command line. So i wanted to create a user with not so much permissions granted like root, yet enough to perform a backup.

1 Answer

As seen in

for mysqldump --single-transaction You need: SELECT, SHOW VIEW, RELOAD, REPLICATIOn CLIENT, EVENT and TRIGGER

GRANT SELECT, SHOW VIEW, RELOAD, REPLICATION CLIENT, EVENT, TRIGGER ON *.* TO 'backup'@'localhost';

And for mysqldump --lock-all-tables you need: LOCK

GRANT LOCK TABLES ON *.* TO 'backup'@'localhost';