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.

Question: Grant EVENT Privilege for Mysql User/Database

Discussion in 'Database Discussions' started by Kurieuo, Mar 23, 2013.

  1. Kurieuo

    Kurieuo Well-Known Member

    Joined:
    Dec 13, 2002
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Australia
    When assigning a user to a database, I notice that cPanel doesn't support EVENT privilege -- at least it's not displaying as a selectable checkbox.

    My question is whether there is a security issue around granting an EVENT privilege for MySQL user on a database?

    If there isn't a security issue, why doesn't cPanel show this privilege -- i.e., do I need to configure something for it to show up?

    Many thanks.
     
    #1 Kurieuo, Mar 23, 2013
    Last edited: Mar 23, 2013
  2. Jeff Shotnik

    Jeff Shotnik Well-Known Member

    Joined:
    Oct 10, 2012
    Messages:
    61
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Denver, Colorado, United States
    cPanel Access Level:
    DataCenter Provider
  3. Kurieuo

    Kurieuo Well-Known Member

    Joined:
    Dec 13, 2002
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Australia
    Thanks Jeff,

    Also received a response from cPanel support, who said:
    It does note that events must be turned on explicitly in /etc/my.cnf (with event_scheduler = 1). It also notes that the events privilege could be easily abused due to there being no way to limit how frequently a scheduled event can be run. At this point in time, it's not supported.​

    Will be submitting this as a feature request so privilege can just be set for a mysql user when adding them to a database.
     
  4. Kurieuo

    Kurieuo Well-Known Member

    Joined:
    Dec 13, 2002
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Australia
Loading...

Share This Page