Description of the permissions required by the mysqldump:
1. For table, mysqldump must have SELECT permission at least.
2, for view mysqldump to have Show view permission.
3, for Trrigger mysqldump to have Trriger permission.
4, if you want to produce a consistent backup mysqldump to have lock tables permissions.
mysql> create user [email protected] '% '; Query OK, 0 rows Affected (0.00 sec) mysql> Grant Select On *. * to [email protected] '% '; Query OK, 0 rows Affected (0.00 sec) Mysql> Grant Show View on *. * to [email protected] '% '; Query OK, 0 rows Affected (0.00 sec) Mysql> Grant lock tables on * * to [email protected] '% '; Query OK, 0 rows Affected (0.00 sec) Mysql> Grant Trigger on * * to [email protected] '% '; Query OK, 0 rows Affected (0.00 sec)
To set a password for the user:
mysql> Update user Set Password=password (' Test-db ') where user= ' dumper ';
Mysqldump the permissions required to back up the database user