- 首先登录数据库
mysql -uroot -pallcam
- 通过下列语句查询event是否开启
show variables like '%sche%';
- 通过执行下列语句,来开启event_scheduler
set global event_scheduler =1;
或者
set global event_scheduler=on;
mysql -uroot -pallcam
show variables like '%sche%';
set global event_scheduler =1;
或者
set global event_scheduler=on;
转载于:https://my.oschina.net/yizhichao/blog/1927418