mysql开启函数功能

今天要自定义函数，但是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)
意思就是我没有开启函数功能

show variables like '%func%';		

此处我已经开启函数功能为ON

设置参数开启函数功能

set global log_bin_trust_function_creators=1;