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;
问题解决。