MySQL said: #1227 – Access denied; you need (at least one of) the SUPER, SET USER 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

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

chrome wdRKKXTBHJ - MySQL said: #1227 - Access denied; you need (at least one of) the SUPER, SET USER 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.cnf

Add:

event_scheduler = 1

Save the file and restart mysql.

service mysqld restart
whoami
Stefan Pejcic
Join the discussion

I enjoy constructive responses and professional comments to my posts, and invite anyone to comment or link to my site.