mysqldump导出报错-Got error: 1449错误解决办法 - MySQL
mysqldump -uroot -pPasswd DBName > /home/lsf/DB_Backup.sql
报错，显示：
Got error: 1449: The user specified as a definer ('xxx'@'') does not exist when using LOCK TABLES
或者直接报：
the user specified as a definer ('xxx'@'') does not exist
解决办法：
给xxx用户再添加一个对全部host都有可以访问的权限：
mysql -uroot -pPasswd
mysql >grant all privileges on *.* to xxx@"%" identified by "Passwd";
mysql >flush privileges;
Tag标签:「权限 mysql mysqldump 1449 」更新时间:「2018-05-08 14:58:00」阅读次数:「2617」