The user specified as a definer ('root'@'%') does not exist的解决方法

The user specified as a definer ('root'@'%') does not exist的主要是由于对视图的操作没有相关权限

解决方法：用Navicat Premium打开MySQL连上数据库后

 

 

权限问题，授权 给 root  所有sql 权限 
mysql> grant all privileges on *.* to root@"%" identified by ".";
刷新权限
mysql> flush privileges;