how to solve Access denied; you need (at least one of) the SUPER privilege(s) for this operation in mysql

Question

Any idea on the solution?

SQL query:


    SET GLOBAL event_scheduler="ON"
    MySQL said: Documentation

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

I am trying to SET GLOBAL event_scheduler="ON"

it seems straight forward, you logt in user hqasn't the necessary privileges, see here for more informtion how to get it https://www.tutorialspoint.com/how-to-add-super-privileges-to-mysql-database — nbk, May 18 '20 at 22:04

score 0 · Answer 1 · answered May 19 '20 at 02:20

Your user doesn't have the necessary MySQL permissions to enable the event scheduler. You'll have to ask your administrator or hosting provider to either enable the scheduler for the server themselves or give you the SUPER privilege (which is basically permissions to manage administration tasks and advanced configuration of the server).

There's nothing extra you can do or nothing wrong with phpMyAdmin, it's simply that your administrator hasn't given you the proper privileges to do that.

how to solve Access denied; you need (at least one of) the SUPER privilege(s) for this operation in mysql

1 Answers1