Create에 해당하는 글들 1 Articles matched 목록이 없습니다. [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; 1