#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

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

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 -
    Follow cPanel >> phpMyAdmin >> Click on database name >> In SQL tab -
    Enter the code as '
SET GLOBAL event_scheduler = ON;'
 
It fixed my issue!

Was this answer helpful?

 Print this Article

Also Read

sendmail cannot be called directly from a shell with the current user id

While sending email using sendmail scirpt, I was getting the error message as - sendmail:...

How to Re-arrange accounts in WHM?

Please go through the following steps on How to Re-arrange accounts in WHM 1. Go to WHM and...

Access to context [/] is denied!

While accessing the site, I was getting the error as -Access to context [/] is denied!Solution...

Error: Website not found. If the website was recently renamed or moved please edit the install to save the new location (Files & Tables tab).

I was getting below error when opening installatron for all installs - Error message - Error:...

MySQL server is currently offline. Error: Too many connections at /usr/local/cpanel/Cpanel/Mysql.pm line 173.

phpMyAdmin and MySQL Databases in cPanel were displaying me the below error -...

Powered by WHMCompleteSolution