mysql - 使用 mysqldump 所需的最低权限是什么

Question

我想创建具有有限权限的 mysql 用户，仅用于 mysqldump。我们可以分配给用户的最低权限是什么，这样他就可以转储和加载数据库，或者这需要管理员权限？

现在我有类似的东西在工作，但我不确定范围:

 DROP user 'dumpuser'@'localhost' ;
 FLUSH PRIVILEGES ;
 GRANT  SELECT ON mysql.proc TO  'dumpuser'@'localhost' IDENTIFIED BY 'dumppwd';
 GRANT  ALL ON dbname.* TO 'dumpuser'@'localhost' IDENTIFIED BY 'dumppwd';
 FLUSH PRIVILEGES;

如果可能，我想进一步限制特权范围。

Answer 1

mysqldump requires at least the SELECT privilege for dumped tables, SHOW VIEW for dumped views, TRIGGER for dumped triggers, and LOCK TABLES if the --single-transaction option is not used. Certain options might require other privileges as noted in the option descriptions.

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