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;

posted @ 2020-06-19 11:03  周世元ISO8859-1  Views(135)  Comments(0Edit  收藏  举报