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=arch...@jab.org