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