MySQL创建触发器的时候报1419错误( 1419 - You do not have the SUPER privilege and binary logging is enabled )...
grant all privileges on *.* to root@'%' identified by 'CTjetrrrr' with grant option; 给用户权限解决方法:第一步,用root用户登录:mysql -u root -p第二步,设置参数log_bin_trust_function_creators为1:set global log_bin_trust_function_creators = 1;再次尝试创建触发器,成功!(同样,在删除触发器报该错
原创
2022-01-05 14:27:53 ·
2294 阅读 ·
0 评论