While running one query 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
#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
Solution -
1. Please make sure you have root access with all the privileges.
2. If you've root access then please make below changes in server's MySQL configuration file:
vi /etc/my.cnf
event_scheduler = 1 -----> add this line
3. Save it.
4. You can also enter the below code from SQL tab under cPanel -
event_scheduler = 1 -----> add this line
3. Save it.
4. You can also enter the below code from SQL tab under cPanel -
Follow cPanel >> phpMyAdmin >> Click on database name >> In SQL tab -
Enter the code as 'SET GLOBAL event_scheduler = ON;'
Enter the code as 'SET GLOBAL event_scheduler = ON;'
It fixed my issue!
