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

[ad_1]

#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


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!

Also Read

Powered by WHMCompleteSolution

[ad_2]

Leave a Comment

Your email address will not be published. Required fields are marked *

To Resolve this issue at just 5$ from ServerExpert

https://serverexpert.io/

For Hosting please visit Hostingwebsite.io

You have Successfully Subscribed!

Open chat