還原mysql資料庫時報錯

標籤：mysql

昨天測試伺服器重啟，mysql不能正常啟動，後來由於業務的需要將內網的資料庫遷移到測試伺服器上，在還原資料庫時報錯如下：

[email protected]:~/sql$ mysql -uroot -p‘1qaz2wsx3edc‘ < csip_business.sql

ERROR 1418 (HY000) at line 2945731: 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)

報錯原因：開啟bin-log

解決方案：編輯主設定檔/etc/my.cnf，將如下3行注釋掉

#log-bin=mysql-bin

#binlog_format=mixed

#server-id      = 1

本文出自 “nagios故障” 部落格，請務必保留此出處http://5250070.blog.51cto.com/5240070/1557687

還原mysql資料庫時報錯