mysqldump: Got error: 1449报错

mysqldump: Got error: 1449: The user specified as a definer ('root'@'%') does not exist when using LOCK TABLES

 

 

于是，将root的host字段改成'%'，再刷新权限，即可：

update mysql.user set host='%' where user='root'

flush privileges;