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