While adding a routine from cPanel > PHPMyAdmin, I was getting this error message –
#1227 – Access denied; you need (at least one of) the SUPER privilege(s) for this operation
![MySQL said: #1227 - Access denied; you need (at least one of) the SUPER, SET USER privilege(s) for this operation chrome wdRKKXTBHJ - MySQL said: #1227 - Access denied; you need (at least one of) the SUPER, SET USER privilege(s) for this operation](https://i0.wp.com/pcx3.com/wp-content/uploads/2023/04/chrome_wdRKKXTBHJ.png?resize=736%2C627&ssl=1)
First check if event scheduler is enabled on the server:
SHOW VARIABLES
WHERE VARIABLE_NAME = 'event_scheduler'
If it is not enabled, enable it from SQL:
SET GLOBAL event_scheduler = ON;
and to make it permanent, edit my.cnf
nano /etc/my.cnf
Add:
event_scheduler = 1
Save the file and restart mysql.
service mysqld restart