解决The user specified as a definer (‘root’@’%’) does not exist 问题

Error querying database. Cause: java.sql.SQLException: The user specified as a definer (‘root’@’%’) does not exist
### Cause: java.sql.SQLException: The user specified as a definer (‘root’@’%’) does not exist

遇到The user specified as a definer (‘root’@’%’) does not exist 问题,原因是没有权限,解决方法如下:
1、添加访问权限

执行SQL:grant all privileges on *.* to root@”%” identified by “.”;

2、更新权限
执行SQL: flush privileges;

sql

问题解决。