Tuesday, 15 September 2015

mysql - What are the minimum privileges required for using mysqldump -



mysql - What are the minimum privileges required for using mysqldump -

i want create mysql user limited privileges utilize mysqldump. minimum privileges can assign user can take dump , load databases or requires admin rights ?

for have working not scope:

drop user 'dumpuser'@'localhost' ; flush privileges ; grant select on mysql.proc 'dumpuser'@'localhost' identified 'dumppwd'; grant on dbname.* 'dumpuser'@'localhost' identified 'dumppwd'; flush privileges;

i want farther limit privilege scope if possible.

mysqldump requires @ to the lowest degree select privilege dumped tables, show view dumped views, trigger dumped triggers, , lock tables if --single-transaction alternative not used. options might require other privileges noted in alternative descriptions.

from http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

mysql mysqldump privileges

No comments:

Post a Comment