Enable Event Scheduler in PHPMyAdmin

saikumar

Registered
Aug 22, 2016
2
0
1
Hyderabad
cPanel Access Level
Root Administrator
How to Turn ON EVENT SCHEDULER IN CPANEL PHPMYADMIN
when i try to turn on it says


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

AS i Have given All the Permissions in privileges Still It Says TO me What COuld be the Solution to Turn On THE event Scheduler
 
Last edited by a moderator:

germany

Member
Jul 15, 2016
17
4
3
Berlin, DE
cPanel Access Level
Website Owner
Just issue appropriate CREATE EVENT SQL from SQL box.

However: your MySQL server needs to have event scheduler enabled AND have EVENT privileges for the database user.

Calling SELECT @@event_scheduler; will tell you if the scheduler is available and enabled.

To enable event scheduler if it's disabled try calling SET GLOBAL event_scheduler := 1; You need the SUPER privilege for this to succeed.
 
  • Like
Reactions: gorilla

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,917
2,248
363
but, how to give user permission as SUPER privilege to an user?
You won't be able to do this as a website owner. You'd need root access to the system.

Thank you.