Navicat Premium
事件计划已关闭。事件只能在服务器启动并开启事件计划时才能处理。
Navicat for MySQL
The event_scheduler is Off. Events can be processed only when server is started with event_scheduler on
第一步、查看事件是否开启
SHOW VARIABLES LIKE 'event_scheduler';
第二步、开启事件
SET GLOBAL event_scheduler = ON;
-- SET @@global.event_scheduler = ON;
-- SET GLOBAL event_scheduler = 1;
-- SET @@global.event_scheduler = 1;
关闭事件相关命令
SET GLOBAL event_scheduler = OFF;
-- SET @@global.event_scheduler = OFF;
-- SET GLOBAL event_scheduler = 0;
-- SET @@global.event_scheduler = 0;
第三步、my.ini最后添加并保存
event_scheduler = 1第四步、重启MySQL服务
