mysql问题，急

huayu

我安装程序上去，程序报错误

1. Warning: mysqli_query() [function.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

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

licess

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