mysql'事件计划已关闭。事件只能在服务器启动并开启事件计划时才能处理。'的警告

通过下列语句查询event是否开启

show variables like '%sche%';

开启event_scheduler sql指令：

SET GLOBAL event_scheduler = ON;
SET @@global.event_scheduler = ON;
SET GLOBAL event_scheduler = 1;
SET @@global.event_scheduler = 1;