Introduction
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.
Procedure
To turn on the Event Scheduler, modify the /etc/my.cnf file and place the following under the [mysqld] section:
event_scheduler=on
Afterwards, restart the MySQL service:
/scripts/restartsrv_mysql
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';
Comments
0 comments
Article is closed for comments.