This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled

 今天在同步本地sql到gcp mysql時發生了這個錯誤

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

切換到 gcp sql 

選擇編輯設定, 在下面新增flag

新增對應flag, log_bin_trust_function_creators 確認後保存。

最後在執行一次同步, 可以了。