BLaZuRE Posted January 3, 2011 Share Posted January 3, 2011 I'm going to create a cron job to automatically backup my databases using --all-databases. Since I'm paranoid about security, what do I need to grant the user? I know I'm granting SELECT and LOCK TABLES, but I've noticed that some people say to add RELOAD or SHOW DATABASES. What do you recommend? Also, I haven't studied closely how mysql is backed up, so how do RELOAD and SHOW DATABASES work for it? This is for version 5.1 Quote Link to comment Share on other sites More sharing options...
BLaZuRE Posted January 11, 2011 Author Share Posted January 11, 2011 Does anyone have any experience with mysqldump permissions, even if it's not with --all-databases? Quote Link to comment Share on other sites More sharing options...
jdavidbakr Posted January 11, 2011 Share Posted January 11, 2011 I'd say create the permissions as minimal as you think you'd need, attempt to run mysqldump with that user and see what you get, then add permissions if it doesn't work right. My backup user has SELECT, SHOW DATABASES, LOCK TABLES, TRIGGER, SHOW VIEW, EXECUTE Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.