Recommend A Backup User / Privileges?

Recommend A Backup User / Privileges?

am 29.04.2010 14:52:20 von Carlos Williams

I downloaded a MySQL script that backs up all my databases
automatically which looks to work amazing. My question is in this
particular script (linked below) there is a section to add a user name
and password for someone who has access to the databases I am
attempting to backup with the script. Now I could just place the MySQL
root user or my own user (admin) account in here which has a plain
text password exposed in the configuration for all to see. Should I
create a generic user in MySQL just for backup roles and privileges? I
don't know enough about GRANT OPTIONS or backups to know if I can
create a dummy user and give him only what he requires to backup the
databases safely or if this script requires the root or someone with
GRANT ALL OPTIONS enabled.

http://sourceforge.net/projects/automysqlbackup/

Thanks for any info!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org