MySQL Enabling the Event Scheduler

Enable Mysql Evemt Schedule:

--Access the MySQL command-line.

mysql -u root -p

--Enable the MySQL scheduler.

SET GLOBAL event_scheduler = ON;

--Verify the status of the MySQL scheduler.

SHOW VARIABLES WHERE VARIABLE_NAME = 'event_scheduler';

--To permanently enable the MySQL scheduler, you need to edit the configuration file my.cnf

nano /etc/my.cnf

--Add the following line under the Mysqld area.

event_scheduler = on

--Here is our configuration.

[mysqld]

event_scheduler = on

--Restart the MySQL service.

service mysql restart