The user specified as a definer (‘root‘@‘%‘) does not exist

在运行好数据sql后，项目运行不起来报以下问题
SELECT command denied to user ‘’@’%’ for column ‘xxxxx’ in table ‘xxxxx’
或者 打不开数据库中视图数据

需要添加用户权限
新建查询
grant all privileges on . to root@"%" identified by “.”;
flush privileges;

参考地址 https://blog.csdn.net/litrainy/article/details/84061065