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 Link to comment https://forums.phpfreaks.com/topic/223303-mysqldump-minimum-user-permissions/ 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? Link to comment https://forums.phpfreaks.com/topic/223303-mysqldump-minimum-user-permissions/#findComment-1157682 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 Link to comment https://forums.phpfreaks.com/topic/223303-mysqldump-minimum-user-permissions/#findComment-1158039 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.