在服务器的mysql中创建自定义函数出错
- WBOY原創
- 2016-06-06 09:40:121053瀏覽
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)
求大神们帮帮想办法
陳述：
本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn