MySQL创建方法Function错误

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)

解决方法：

1）执行：mysql> SET GLOBAL log_bin_trust_function_creators = 1;

此方法重启失败。

2）修改my.cnf文件：

在my.ini(Linux下为my.conf)文件中[mysqld]标识后加上如下代码

log-bin-trust-function-creators=1

此方法需要重启数据库

具体参照：

http://stackoverflow.com/questions/26015160/deterministic-no-sql-or-reads-sql-data-in-its-declaration-and-binary-logging-i