#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

This webpage is not found - Cannot export database

While exporting the database zip file from cPanel >> phpMyAdmin as well from SSH, I was...

Failed to send your message. Please try later or contact the administrator by another method - WordPress Contact Form is not working

While sending email from WordPress's contact form, I was getting below error -Failed to send your...

How to allow remote MySql connection to only one IP?

There may be a case in which one of the cPanel user request you to provide access to Mysql...

How to enable Open SSL on WHM?

Before enabling open SSL, you can check whether it is already enabled on your server. Please fire...

How to change the primary IP address of a WHM/cPanel (centOS/RHEL) based servers?

1. Steps for WHM: I. Log into WHM >> Basic cPanel & WHM Setup II. Change the Primary...

Powered by WHMCompleteSolution