Re: How to create a backup-only user

[Scott Nemes]

The backup user has to be able to at minimum SELECT from the tables you want to backup (assuming you are using mysqldump or similar to do a SQL backup). However that is a minimum; if you want to do consistent snapshots, the backup user will need the LOCK TABLES permission as well, and if you want replication information then it will need the RELOAD and REPLICATION CLIENT permissions.

GRANT SELECT, LOCK TABLES, RELOAD, REPLICATION CLIENT ON yourdatabase.* TO 'backup'@'localhost' IDENTIFIED BY PASSWORD 'password'

Replace yourdatabase.* with *.* if you want the backup user to be able to backup any database (with the caveat that the user can then be used to read data from any database).

--
Scott Nemes
MySQL DBA

http://www.linkedin.com/in/scottnemes
http://www.twitter.com/ScottNemes



Edited 1 time(s). Last edit at 11/08/2012 05:22PM by Scott Nemes.