Dev/DB
[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)
hau
2020. 6. 18. 17:13
728x90
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)
mysql> use mysql
mysql> show tables;
mysql> SET GLOBAL log_bin_trust_function_creators = ON;
혹은
mysql> SET GLOBAL log_bin_trust_function_creators = 1;
이런 SQL 쿼리를 한번 날려준 뒤
동일한 함수생성문을 선언했더니 에러가 나지 않았습니다.
혹시 이 방법이 안되신다면 저 커뮤니티를 참조하셔서 다른방법으로 해결해 보시기 바랍니다.
https://oooobang.tistory.com/16
http://www.mysqlkorea.com/gnuboard4/bbs/board.php?bo_table=community_03&wr_id=1965
728x90