mysqldump不能使用SELECT,LOCK TABLES,SHOW VIEW,EVENT,TRIGGER权限
我的系统:CentOS 6.5 + MySQL 5.6 我为mysqldump创build了一个备份用户: CREATE USER 'usr_backup'@'localhost' IDENTIFIED BY 'XXX'; GRANT USAGE ON *.* TO 'usr_backup'@'localhost' IDENTIFIED BY "XXX"; GRANT SELECT, LOCK TABLES ON `mysql`.* TO 'usr_backup'@'localhost'; GRANT SELECT, LOCK TABLES, SHOW VIEW, EVENT, TRIGGER ON <my schema name>.* TO 'usr_backup'@'localhost' IDENTIFIED BY "XXX"; Mysql转储命令: mysqldump -uusr_backup -pXXX –add-drop-database –add-drop-table –add-drop-trigger –allow-keywords –comments […]