#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!
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to reset SSH port back to default port 22?

In some situations most of us may come across a problem that we are able to log into the WHM but...

How to setup the root login alert notification email?

Its very important to keep a check on your servers and who logs into the server, From security...

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 install mod_pagespeed on WHM?

'mod_pagespeed' is module of Apache which is nothing but plugin which is used for compressing the...

How to enable Hot Link Protection in cPanel?

To avoid other sites to use your website's bandwidth, you can enable the hot link protection....

Powered by WHMCompleteSolution