mysql主从出错：Replicate_Wild_Ignore_Table: Last_Errno: 1418 Last_Error: Error ‘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_tr ust_function_creators variable)’ on query. Default database: ‘test123’. Query: ‘CREATE DEFINER=`root`@`%` FUNCTION `hello`(s char(20)) RETURNS char(50) CHARSET utf8mb4
报错信息： Replicate_Wild_Ignore_Table: Last_Errno: 141… 继续阅读 mysql主从出错：Replicate_Wild_Ignore_Table: Last_Errno: 1418 Last_Error: Error ‘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_tr ust_function_creators variable)’ on query. Default database: ‘test123’. Query: ‘CREATE DEFINER=`root`@`%` FUNCTION `hello`(s char(20)) RETURNS char(50) CHARSET utf8mb4
- 发表于：
-
作者：
sre
- 分类： SRE
- 标签： MySQL
- 发表评论: mysql主从出错：Replicate_Wild_Ignore_Table: Last_Errno: 1418 Last_Error: Error ‘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_tr ust_function_creators variable)’ on query. Default database: ‘test123’. Query: ‘CREATE DEFINER=`root`@`%` FUNCTION `hello`(s char(20)) RETURNS char(50) CHARSET utf8mb4