mysql数据库导入表或者视图添加了权限时报错specified as a definer (”@’%') does not exist

The user specified as a definer (”@’%') does not exist完美解决方法

问题描述：

权限问题，授权 给 root  所有sql 权限

解决办法：

运行下面两条sql命令即可

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

flush privileges;