Originally Posted by timgerr
I have a backup script that I created and I now want to backup my mysql database. I need to use the mysqldump. Since the username and password will be in a script I need to create a user that can only dump the database. What permissions does this user need? I only want to give what is needed.
Also since you'll have a username and password in the script, make sure the permissions for the script itself are only readable by the user that will be running the command, I'm assuming root in it's own crontab, etc. This way no other user can gain access to your database with the said username by simply viewing the script unless they have root or whatever user running it access.