导入SQL文件MySQL报1418错误的解决办法

目录

• MySQL导入时报错
• 解决方法

MySQL导入时报错

[ERR] 1418 - 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)

解决方法

执行查询语句：

set global log_bin_trust_function_creators=TRUE;

为防止重启失效，可在my.cnf配置文件中添加：

log_bin_trust_function_creators=1