分类: MySQL

mysqldump导出报错-Got error: 1449错误解决办法

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;

相关文章

发表新评论