錯誤信息如下:
以下是引用片段:
ErrorCode:1418
ThisfunctionhasnoneofDETERMINISTIC,NOSQL,orREADSSQLDATAinitsdeclarationandbinaryloggingisenabled(you*might*wanttousethelesssafelog_bin_trust_function_creatorsvariable)
(0mstaken)
解決方法如下:
1. MySQL> SET GLOBAL log_bin_trust_function_creators = 1;
2. 系統啟動時 --log-bin-trust-function-creators=1
3. 在my.ini(Linux下為my.conf)文件中 [MySQLd] 標記後加一行內容為 log-bin-trust-function-creators=1