mysql函数：java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist

如果是导入的数据库，函数容易发生权限问题：

授权 给 root  所有sql 权限

mysql> grant all privileges on *.* to root@"%" identified by ".";
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)