mysql问题，急

huayu 发表于 2012-10-2 22:10:53

我安装程序上去，程序报错误Warning: mysqli_query() : (HY000/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) in提示要开启什么二进制日记 log_bin_trust_function_creators ＝ 1

huayu 发表于 2012-10-2 22:16:40

回复 1# 的帖子

补充一下，我使用了my-huge.cnf 配置文件

licess 发表于 2012-10-3 08:34:29

mysql -uroot -p 输入密码登录后
show variables like '%func%';
+---------------------------------+-------+
| Variable_name | Value |
+---------------------------------+-------+
| log_bin_trust_function_creators | OFF |
+---------------------------------+-------+
1 row in set (0.00 sec)
可能是这样，再
set global log_bin_trust_function_creators=1;

再 show variables like '%func%';

quit 退出

重启mysql

页: [1]

VPS侦探论坛's Archiver

mysql问题，急

回复 1# 的帖子