2

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.

Improve this question

1 Answer 1

Reset to default
1

As seen in http://www.fromdual.com/privileges-of-mysql-backup-user-for-mysqldump

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';
Improve this answer
1

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .