Enable Event Scheduler in PHPMyAdmin

saikumar

• August 22, 2016 08:27

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

• 

  syslint

  • August 22, 2016 16:08

  Are you running mysql in strict mode ?

  0
• 

  saikumar

  • August 23, 2016 11:15

  Are you running mysql in strict mode ?

  
  No, and the other thing is that i cant find my.cnf/my.ini in my Server i,e CPANEL

  0
• 

  germany

  • August 24, 2016 16:35

  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.

  0
• 

  cPanelMichael

  • August 24, 2016 19:08

  Hello, You may also find the following StackOverflow thread helpful: Can I set a MySQL event schedule using phpMyAdmin? Thank you.

  0
• 

  harshad

  • May 23, 2017 09:57

  but, how to give user permission as SUPER privilege to an user?

  0
• 

  cPanelMichael

  • May 29, 2017 15:44

  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.

  0

Please sign in to leave a comment.