Caused by: java.sql.SQLException: The user specified as a definer (‘root‘@‘%‘) does not exist

Caused by: java.sql.SQLException: The user specified as a definer (‘root’@’%’) does not exist

java.sql.SQLException：指定为定义程序的用户（‘root’@’％’）不存在
权限问题

授权给 root 所有sql 权限

在Navicat for MySQL中查询中，按F6进入命令列界面
输入
mysql> grant all privileges on . to root@"%" identified by “.”;
mysql> flush privileges;