In some cases, we need to enable the event_scheduler in MySQL for our databases. While this is enabled by default in MySQL 8, we will need to enable this in the /etc/my.cnf in previous versions.
To turn on the Event Scheduler, modify the /etc/my.cnf file and place the following under the [mysqld] section:
Afterwards, restart the MySQL service:
Once that is completed, you can log into MySQL and then test to see if the option is enabled using this command:
SHOW GLOBAL VARIABLES LIKE 'event_scheduler';