一、检查EVENT是否开启
使用root用户登录,在命令框中输入:show variables like '%event_scheduler%';
二、开启EVENT
一般情况下是默认关闭的,所以需要打开EVENT,打开方式如下:
开启event_scheduler sql指令:
SET GLOBAL event_scheduler = ON;
SET @@global.event_scheduler = ON;
SET GLOBAL event_scheduler = 1;
SET @@global.event_scheduler = 1;
之后再查询一下会发现已经开启
三、关闭EVENT
关闭event_scheduler指令:
SET GLOBAL event_scheduler = OFF;
SET @@global.event_scheduler = OFF;
SET GLOBAL event_scheduler = 0;
SET @@global.event_scheduler = 0;