MySQL events_schedule='ON' fails due to privileges

Question

I’m trying to turn events on. If I execute SET GLOBAL event_schedule="ON" , MySQL gives me this error:

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

I’m using the root user of my WHM and open cPanel of one of the accounts I have.

Answer 1

There is a difference between Server Root and MySql User Privileges. You need to give yourself MySql privileges. See MySQL: Grant **all** privileges on database

Also this link has some valuable mysql commands that you will find useful: http://pentestmonkey.net/cheat-sheet/sql-injection/mysql-sql-injection-cheat-sheet