mysql8.0以上(高版本)导入视图报错

如下错误：

[HY000][1449] The user specified as a definer ('root'@'%') does not exist
You are not allowed to create a user with GRANT

解决办法

注意修改test为自己的数据库名

use mysql;
update user set host='%' where user='root';
grant all privileges on test.* to root@'%';
flush privileges;