[Error][MySQL]ERROR 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)

◼ 에러메세지

ERROR 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)

◼ 해결방법

• 다음 SQL 쿼리를 실행한 후 함수를 생성하면 에러가 안 뜬다.

  SET GLOBAL log_bin_trust_function_creators = 1;