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

上一篇:【数据结构&算法】06-链表类型及LRU算法


下一篇:最近公共祖先 LCA(Least Common Ancestors)