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