Search code examples
mysqldatabasephpmyadminlocalhostmysql-event

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

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"

Solution

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