[Mysql] - ERROR 1418 (HY000): This function has none of DETERMINISTIC 해답

Mysql 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;


반응형
: