mysql如何设置job任务自动启动

1，检查当前的job

mysql> use databases;

Database changed

mysql> show events;
+--------+------------+----------------+-----------+-----------+------------+----------------+----------------+---------------------+------+---------+------------+----------------------+----------------------+--------------------+
| Db     | Name       | Definer        | Time zone | Type      | Execute at | Interval value | Interval field | Starts              | Ends | Status  | Originator | character_set_client | collation_connection | Database Collation |
+--------+------------+----------------+-----------+-----------+------------+----------------+----------------+---------------------+------+---------+------------+----------------------+----------------------+--------------------+
| yichen | event_test | root@localhost | +00:00    | RECURRING | NULL       | 1              | SECOND         | 2016-12-22 00:00:00 | NULL | ENABLED |          1 | utf8                 | utf8_general_ci      | utf8_general_ci    |
+--------+------------+----------------+-----------+-----------+------------+----------------+----------------+---------------------+------+---------+------------+----------------------+----------------------+--------------------+

1 row in set (0.00 sec)

2，检查是否开启了自动启动

mysql> show global variables like '%event_scheduler%';

+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| event_scheduler | ON    |
+-----------------+-------+
1 row in set, 1 warning (0.00 sec)

3，设置job自动启动

mysql> set global event_scheduler = on;
Query OK, 0 rows affected (0.00 sec)

4，设置mysql重启后,job能自动启动
编辑/etc/my.cnf文件,在[mysqld]下添加event_scheduler=1