Results 1 to 3 of 3

Thread: Using MySQL Triggers

  1. #1
    Registered Member
    Join Date
    Feb 2005
    Posts
    43

    Default Using MySQL Triggers

    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. #2
    Registered Member
    Join Date
    Oct 2003
    Posts
    28

    Default

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

  3. #3
    Registered Member
    Join Date
    Oct 2003
    Posts
    28

    Default

    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. mysqldump for triggers and procedures.
    By gwaland in forum Database Discussions
    Replies: 3
    Last Post: 05-28-2014, 12:09 PM
  2. Replies: 13
    Last Post: 06-15-2010, 04:31 PM
  3. Replies: 13
    Last Post: 06-15-2010, 04:31 PM
  4. CPupdate pkgacct 2.3 triggers errors mailman
    By gemininetcom in forum General Discussion
    Replies: 10
    Last Post: 11-07-2004, 01:12 PM
bargain