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.

trigger defined in phpMyAdmin has cpses_XXX DEFINER

Discussion in 'Database Discussions' started by TomKu, Mar 12, 2014.

  1. TomKu

    TomKu Member

    Joined:
    Oct 10, 2011
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Chicago
    cPanel Access Level:
    Root Administrator
    ...so it cannot be used

    mysql> show triggers;
    +----------+--------+--------+---------------------------------------+--------+---------+----------+----------------------------+----------------------+----------------------+--------------------+
    | Trigger | Event | Table | Statement | Timing | Created | sql_mode | Definer | character_set_client | collation_connection | Database Collation |
    +----------+--------+--------+---------------------------------------+--------+---------+----------+----------------------------+----------------------+----------------------+--------------------+
    | trigger1 | UPDATE | table1 | BEGIN
    SET NEW.ts2 = OLD.ts1;
    END | BEFORE | NULL | | cpses_fr2zcKiKlF@localhost | utf8 | utf8_general_ci | latin1_swedish_ci |
    +----------+--------+--------+---------------------------------------+--------+---------+----------+----------------------------+----------------------+----------------------+--------------------+

    Because the trigger is 'Before UPDATE' any update statement cannot be executed:
    ERROR 1449 (HY000): The user specified as a definer ('cpses_fr2zcKiKlF'@'localhost') does not exist

    MySQL 5.1.73
    WHM 11.42.0 21
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    651
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
Loading...

Share This Page