Results 1 to 3 of 3

Thread: Using MySQL Triggers

  1. #1
    Registered Member
    Join Date
    Feb 2005

    Default Using MySQL Triggers


    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.


  2. #2
    Registered Member
    Join Date
    Oct 2003


    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
    Last edited by Ivanner; 03-17-2009 at 02:42 PM.

  3. #3
    Registered Member
    Join Date
    Oct 2003


    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.

Similar Threads

  1. Further Customize Exim Rate Limit Triggers
    By cPanelDavidG in forum Archived Feature Requests
    Replies: 3
    Last Post: 01-16-2012, 09:05 AM
  2. Replies: 13
    Last Post: 06-15-2010, 04:31 PM
  3. Replies: 1
    Last Post: 04-21-2007, 01:23 AM
  4. CPupdate pkgacct 2.3 triggers errors mailman
    By gemininetcom in forum cPanel & WHM Discussions
    Replies: 10
    Last Post: 11-07-2004, 01:12 PM
  5. Replies: 0
    Last Post: 06-27-2004, 02:53 AM