今天在mysql導(dǎo)入sql文件的時候出現(xiàn)以下錯誤:
提示可能需要 log_bin_trust_function_creators 變量,查看mysql 官方文檔 (
),需要設(shè)置其值為1 global log_bin_trust_function_creatorssystem variable to 1.
mysql> SET GLOBAL log_bin_trust_function_creators = 1;
example:
ERROR 1418 (HY000) at line 68: 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;
聯(lián)系客服