(mysql数据库报错)The user specified as a definer ('root'@'%') does not exist

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

解决办法:

(1)登录MYSQL

     以管理员身份运行cmd
      >mysql -u root -p
      >密码

(2)更改权限

    mysql> grant all privileges on *.* to root@"%" identified by ".";
    Query OK, 0 rows affected (0.00 sec)

   // 刷新系统权限表
     mysql> flush privileges;
     Query OK, 0 rows affected (0.00 sec)

原文地址:https://www.cnblogs.com/webttt/p/9054330.html