[bug] MySQL： The user specified as a definer ('root'@'%') does not exist

错误1

gciantispider.getchildlst does not exist

原因

getchildlst创建失败

解决

在mysql中设置mysqld中加上log_bin_trust_function_creators=1

错误2

org.hibernate.engine.jdbc.spi.SqlExceptionHelper]:146 - The user specified as a definer ('root'@'%') does not exist

原因

root用户没有访问数据库权限

解决

 

参考

log_bin_trust_function_creators错误解决_MySQL

http://www.gxlcms.com/mysql-299928.html

数据库报错The user specified as a definer ('root'@'%') does not exist 解决方法

https://blog.csdn.net/qq_25615395/article/details/78104642

MySQL 8.0中为root用户授予所有权限

http://www.cocoachina.com/cms/wap.php?action=article&id=64385