Minimum Privileges Required to Backup MySQL Databases

Posted:

Monday, June 6th, 2016

Last modified:

Tuesday, June 7th, 2016

Topics:

How to create a mysql user for running automated backups.

GRANT SELECT, RELOAD, LOCK TABLES
ON *.* 
TO  'MysqlBackupUser'@'localhost'
IDENTIFIED BY 'MySQLBackupUserPassword'

References

MySQL Permissions for backup using mysqldump and/or ec2-consistent-snapshot

Available Wiki Topics

@TODO	chrome	Excel	ls	Photography	sysconfig
acpi	Composer	extensions	lsof	PHP	Tar
AJAX	Compser	file system	Mamp	PhpStorm	Taxonomy
Algorithms	Cookies	Firefox	math	Plesk	TCP
Android	CoreAudio	FTP	Module Development	Postgresql	Tests
angular	Coverage	Git	mod_rewrite	Programming	Theme Development
angular-1.x	cron	Gnome	MongoDB	Python	This wiki page is incomplete
Ansible	CSS	grep	Mothership Theme	Queues	Time and Date
Apache	cURL	Gunzip	MySQL	Rackspace	Tomcat
APT	Cygwin	gzip	mysqldump	Rails	Typography
Aptana	Data Structures	Hardware	Networking	React	Ubuntu
Arrays	Database	htaccess	NFS	REHL	vagrant
Backups	Debug	HTML	Nginx	RSpec	Variables
BAM	Demonstrations	HTTP	ngrok	Ruby	Views
Bash	dev tools	Ignore	Node	Sass	Views Data Export
benchmarking	Devops	images	Nodequeues	SCP	VirtualBox
Bitbucket	dig	Intellij	Not fully tested	Security	VirtualHosts
Blocks	directivess	iptables	npm	sed	wget
Bower	Drupal	Jasmine	nvm	SQL	Wiki
Caching	Drupal5	Java	OOP/D	SSH	Win7
cat	Drupal6	Javascript	OSX	SSHFS	WordPress
CDbCriteria	Drupal7	Jest	OSX Server	Strings	WWW
CentOs	drush	jQuery	Pagination	Sublime Text	XAMPP
CentOs5	Editors and IDEs	kill	Pantheon	Surviving Obsolescence	Xdebug
CentOs6	EPEL	Legacy	PDO	Syntax	Xfce
CGridView	errors	Links	Performance	sysadmin	Yii
Charsets	ES6	Linux	perl

The operator of this site makes no claims, promises, or guarantees of the accuracy, completeness, originality, uniqueness, or even general adequacy of the contents herein and expressly disclaims liability for errors and omissions in the contents of this website.