If you get the error

MySQL said: Access denied; you need the SUPER privilege for this operation

when inserting data into an table with a trigger, you should check definier of the trigger. Mine was empty and caused this error. Re-Creating the trigger solved the problem and a proper definier was set.

To dump all you triggers you can use the following query

SELECT CONCAT_WS( " ", "CREATE TRIGGER",  TRIGGER_NAME,  ACTION_TIMING,  EVENT_MANIPULATION,  "ON",  EVENT_OBJECT_TABLE,  "FOR EACH ROW",  ACTION_STATEMENT) 'create_trigger' 
FROM information_schema.triggers