mysql Access denied； you need (at least one of) the SUPER privilege(s) for this operation

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';