mysql 创建触发器:[Err] 1419 - You do not have the SUPER privilege and binary logging is enabled ?
helloworld 提问于:2018-07-11
0 0

提示如下:

[SQL]create trigger tri_test
before update on ts_order
for each row
set NEW.updateTime = NOW();
[Err] 1419 - You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
  • 所有回答
ren_xian 回答于:2018-07-12
0 0

权限不足,使用root创建吧

我来回答    mysql 创建触发器:[Err] 1419 - You do not have the SUPER privilege and binary logging is enabled ?