Introduction
How do I enable the Event Scheduler in MySQL? I try toggling it in the Events tab of a cPanel user's phpMyAdmin interface, but I get this error:
#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
Procedure
Similar to the reverse instructions found in How to turn off Event Scheduler in MySQL 8, event_scheduler needs to be enabled or disabled globally on the server. The persistent way to do that is by enabling it via the /etc/my.cnf file.
To turn on the Event Scheduler, modify (see: How to edit a file on the command-line) the /etc/my.cnf file and place the following under the [mysqld] section:
event_scheduler=ON
Afterward, restart the MySQL service:
/scripts/restartsrv_mysql
To confirm the Event Scheduler is enabled, you can see the toggle has changed in the Events tab of phpMyAdmin, or you can run this command to see the value of the variable in MySQL:
mysql -e "SELECT @@event_scheduler;"