在服务器的mysql中创建自定义函数出错
- WBOYOriginal
- 2016-06-06 09:40:121055browse
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)
求大神们帮帮想办法
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql-学渣妹纸·······servlet,jsp跳转问题Next article：mysql数据库，在查询列名里子查询一列由两列组合去重的个数如何实现？