Mysql
[Mysql] - ERROR 1418 (HY000): This function has none of DETERMINISTIC 해답
Vivara
2012. 4. 23. 11:48
반응형
ERROR 1418 (HY000): 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)
1. mysql 서버를 시작할 때 다음 옵션을 추가 한다.
--log-bin-trust-function-creators=1
2. 계정에 접속해서 다음을 실행한다.
mysql>SET GLOBAL log_bin_trust_function_creators = 1;
반응형