錯(cuò)誤信息如下:
| 以下是引用片段: error code : 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) (0 ms taken) |
解決方法如下:
1. mysql> set global log_bin_trust_function_creators = 1;
2. 系統(tǒng)啟動(dòng)時(shí) --log-bin-trust-function-creators=1
3. 在my.ini(linux下為my.conf)文件中 [mysqld] 標(biāo)記后加一行內(nèi)容為 log-bin-trust-function-creators=1
新聞熱點(diǎn)
疑難解答
圖片精選