#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

Is it possible to add multiple backup destinations on the cPanel server?

Is it possible to add multiple backup destinations on the cPanel server?Solution :- Yes, its...

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:...

Fatal error: Class 'JCache' not found in /libraries/joomla/factory.php - Joomla Issue

After updating the Joomla, I was getting Fatal error: Class 'JCache' not found in...

How to install composer on cPanel server- Locally - inside the user's directory?

Composer is as tool which is used to manage the dependencies between the PHP softwares and...

JFolder::create: Could not create directory - Warning! Failed to move file. Unable to find install package - Joomla Issue

While installing Extension in Joomla I was getting below error message - JFolder::create: Could...

Powered by WHMCompleteSolution