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
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.cnfAdd:
event_scheduler = 1Save the file and restart mysql.
service mysqld restart