[MySQL] 함수 생성 시 에러 발생 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)

---

 

 

상황

함수를 생성하려고 했으나 아래와 같은 에러메시지가 발생함.

에러메시지

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)

 

해결

DB의 root로 접속하여 아래 쿼리를 수행해주고 재생성

SET GLOBAL log_bin_trust_function_creators = 1;