创建触发器,显示You do not have the SUPER privilege and binary logging is enabled
CREATE TRIGGER `delete_lottery_template` AFTER DELETE ON `lottery_info` FOR EACH ROW
BEGINDELETE FROM lottery_template WHERE lottery_template_id = old.lottery_template_id;
END;
解决方法:
用root用户登录:mysql -u root -p,之后
set global log_bin_trust_function_creators = 1;flush privileges;
创建触发器成功