mysql代码1418_MySQL 1418异常解决办法

mysql 1418错误解决方法

某一日，发现DB复制有问题

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_trust_function_creators variable)' on query. Default database: 'elearning_project_sxgzjs'. Query: 'CREATE DEFINER=`root`@`localhost` FUNCTION rand_string(n INT)

RETURNS VARCHAR(255)

BEGIN

DECLARE chars_str varchar(100) DEFAULT '23456789abcdefghijkmnpqrstuvwxy';

DECLARE return_str varchar(255) DEFAULT '';

DECLARE i INT DEFAULT 0;

WHILE i < n DO

SET return_str = concat(return_str,substring(chars_str , FLOOR(RAND()*31 ),1));

SET i = i +1;

END WHILE;

RETURN return_str;

END'

可以用命令行方式登录MYSQL执行下面的语句解决问题：

mysql> SET GLOBAL log_bin_trust_function_creators = 1;

原创文章，转载请注明： 转载自搞代码

微信 赏一包辣条吧~

支付宝 赏一听可乐吧~