MySQL function 생성 실패시

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)

show global variables like 'log_bin_trust_function_creators';

off 일경우

SET GLOBAL log_bin_trust_function_creators = 'ON';

또는
SET GLOBAL log_bin_trust_function_creators = 1;