mysqldump 备份所需要的权限说明:
1、对于table,mysqldump 最少要有select权限
2、如果要产生一份一致的备份,mysqldump 要有lock tables权限
3、对于view,mysqldump 要有show view权限
4、对于trigger,mysqldump 要有trriger权限
5、对于event,mysqldump 要有event权限
创建用户并授权:
create user dbbackup@localhost identified by '123456';
grant select, reload, lock tables, replication client, show view, triger to dbbackup@localhost;
flush privileges;