查看是否开启:
mysql> show variables like 'event_scheduler';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | OFF |
+-----------------+-------+
1 row in set (0.00 sec)
---------------------
开启方法:
# 方法1:
mysql> set global event_scheduler=on;
Query OK, 0 rows affected (0.00 sec)
# 方法2:
mysql> set global event_scheduler=1;
Query OK, 0 rows affected (0.00 sec)