在还原MySQL function时,发现导入不进去,提示you *might* want to use the less safe log_bin_trust_function_creators variable;
发现是MySQL的配置问题,需要配置binlog中信任创建方法;
即时生效的设置方法:
mysql> SET GLOBAL log_bin_trust_function_creators = 1;
配置文件my.cnf设置方法:
mysqld中设置log_bin_trust_function_creators = 1
参考:https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html