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.

Create Trigger

Discussion in 'General Discussion' started by Aldweb, Apr 14, 2009.

  1. Aldweb

    Aldweb Well-Known Member

    Joined:
    Feb 18, 2004
    Messages:
    66
    Likes Received:
    0
    Trophy Points:
    6
    I am having trouble with a user to create a trigger in mysql. The following message appears:

    SQL Error: 1227: Access denied; you need the SUPER privilege for this operation


    How to fix?

    Thanks
     
  2. hzJayJ

    hzJayJ Well-Known Member

    Joined:
    Nov 14, 2008
    Messages:
    76
    Likes Received:
    1
    Trophy Points:
    8
    Are you executing these commands via ssh and are you using jail shell? Also which command are you trying to execute.

    If you are using jail shell some commands need to have root access.
     
  3. d_t

    d_t Well-Known Member

    Joined:
    Sep 20, 2003
    Messages:
    243
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Bucharest
    In MySQL 5.0.x only superuser can create triggers. Upper MySQL versions fix this problem but are not supported by cPanel.
     
Loading...

Share This Page