The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Enable Event Scheduler in PHPMyAdmin

Discussion in 'Database Discussions' started by saikumar, Aug 22, 2016.

Tags:
  1. saikumar

    saikumar Registered

    Joined:
    Aug 22, 2016
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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
     
    #1 saikumar, Aug 22, 2016
    Last edited by a moderator: Aug 22, 2016
  2. syslint

    syslint Well-Known Member

    Joined:
    Oct 9, 2006
    Messages:
    253
    Likes Received:
    6
    Trophy Points:
    168
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    Are you running mysql in strict mode ?
     
  3. saikumar

    saikumar Registered

    Joined:
    Aug 22, 2016
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Hyderabad
    cPanel Access Level:
    Root Administrator
    No, and the other thing is that i cant find my.cnf/my.ini in my Server i,e CPANEL
     
  4. germany

    germany Member

    Joined:
    Jul 15, 2016
    Messages:
    16
    Likes Received:
    3
    Trophy Points:
    3
    Location:
    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.
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,173
    Likes Received:
    1,295
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
  6. harshad

    harshad Registered

    Joined:
    May 23, 2017
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    nashik
    cPanel Access Level:
    Website Owner
    but, how to give user permission as SUPER privilege to an user?
     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,173
    Likes Received:
    1,295
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    You won't be able to do this as a website owner. You'd need root access to the system.

    Thank you.
     
Loading...

Share This Page