GRANT SELECT ON *.* TO backup@localhost IDENTIFIED BY 'password'; grant show view on *.* to backup@localhost; grant lock tables on *.*to backup@localhost; grant trigger on *.* to backup@localhost;
创建一个只读的mysql账户并且可以使用mysqldump导出
发表评论
GRANT SELECT ON *.* TO backup@localhost IDENTIFIED BY 'password'; grant show view on *.* to backup@localhost; grant lock tables on *.*to backup@localhost; grant trigger on *.* to backup@localhost;