mysql function 생성 에러

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> SET GLOBAL log_bin_trust_function_creators = 1;

# vi /etc/my.cnf

[mysqld]

log_bin_trust_function_creators=1

mysql 시작 할 때 --log-bin-trust-function-creators=1