解决mysql不能创建函数

    xiaoxiao2022-07-15  175

    以下是引用片段:  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. 系统启动时 --log-bin-trust-function-creators=1  方法3. 在my.ini(linux下为my.conf)文件中 [mysqld] 标记后加一行内容为 log-bin-trust-function-creators=1  

    ====================================分割线================================

    最新内容请见作者的GitHub页:http://qaseven.github.io/

    最新回复(0)