I downloaded a MySQL backup script today since I have 3 or 4
relatively small databases. The script can be found here:

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

Now I was wondering if I can create a local database user
'backup'@'localhost' & grant him a level of permissions needed to
perform a 'mysqldump' so he can backup the databases to an directory
on the server. My Question is what level or permissions does a user
need to perform a 'mysqldump' on a database since that particular
user's password will be entered into the script noted above via plain
text. I am scared the password will be compromised & that would be bad
if it's root or someone who has GRANT ALL PRIVILEGES ON *.*.

Can you guys recommend something for me here? I don't really know
enough about MySQL 'grant' permissions to determine which would work
or if the 'backup' user would require high level privileges.

-Carlos

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to