Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Question: Grant EVENT Privilege for Mysql User/Database

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

  1. Kurieuo

    Kurieuo Well-Known Member

    Joined:
    Dec 13, 2002
    Messages:
    100
    Likes Received:
    0
    Trophy Points:
    166
    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
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Kurieuo

    Kurieuo Well-Known Member

    Joined:
    Dec 13, 2002
    Messages:
    100
    Likes Received:
    0
    Trophy Points:
    166
    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:
    100
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Australia
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice