Mysql 创建自定义函数报 :
问题一 :1.This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its de
set global log_bin_trust_function_creators=1
问题二 .1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
1.使用命令行进入mysql:
mysql -uroot -proot
2. 设置 super 权限 //注释:kyxj 为账户名称
grant super on *.* TO 'kyxj'@'localhost';
此处就设置完成;运行自定义函数即可。
删除 super 权限
revoke super on *.* from 'kyxj'@'localhost';