2 wang8831567 wang8831567 于 2015.06.27 15:09 提问

在服务器的mysql中创建自定义函数出错

我的一台机器,连接服务器上mysql,创建自定义函数报错
[Err] 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)
然后我设置set global log_bin_trust_function_creators = 1;
接着又报错,不知道如何解决
[Err] 1419 - You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)
求大神们帮帮想办法

Csdn user default icon
上传中...
上传图片
插入图片