1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Using MySQL Triggers

Discussion in 'General Discussion' started by veronicabend, Mar 13, 2009.

  1. veronicabend

    veronicabend Member

    Joined:
    Feb 25, 2005
    Messages:
    43
    Likes Received:
    0
    Trophy Points:
    6
    Hi!

    A person who has an account on server wants to use MySQL triggers. I found out he cannot unless I manually grant him SUPER privilege. I would like to know more before proceeding.

    How can this affect overall server performance? Which doors do I open by giving this person this privilege, could he change mysql server configuration or access other accounts databases? What happens if he has a logic error in a trigger he creates, could it crash our mysql server?

    I have not used triggers before, and I read that you need to be careful using them. I just would like to have more accurate information to make a decision.

    Thanks for any help.

    V.
     
  2. Ivanner

    Ivanner New Member

    Joined:
    Oct 13, 2003
    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    1
    I am on the same boat. I used the phpMyAdmin to give SUPER privileges to an user and somehow it gets reset to USAGE after a while.

    EDIT: Here is the answer to avoid user losing permissions http://forums.cpanel.net/showthread.php?t=101817
     
    #2 Ivanner, Mar 17, 2009
    Last edited: Mar 17, 2009
  3. Ivanner

    Ivanner New Member

    Joined:
    Oct 13, 2003
    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    1
    Well, after some back and forth with a customer, we found out that once you assign the SUPER permissions on mySQL to an user, that user SHOULD NOT use phpMyAdmin, or the permissions will get reset to USAGE.
    So my client ended up using an external app to access his mysql database and still retain the SUPER privileges.
     

Share This Page