Mysql报错1449 - The user specified

mysql 数据库通过文件还原后报错：
1449 - The user specified as a definer ('root'@'%') does not exist

分析原因：一般是因为权限导致的。通过以下脚本赋权即可解决。

grant all privileges on *.* to root@"%" identified by "."; 

flush privileges;