Mysql异常: java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist

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

在Navicat for MySQL中按F6进入命令列界面

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

mysql> flush privileges;

原文地址:https://www.cnblogs.com/zhou-shi-yuan-ISO8859-1/p/13161905.html