i've some trouble, since 1 day, i want to create a trigger, but i couldn't identify the source of the problem.
This is in fact only the privilege, as is indeed privilege "SUPER". But in the wiki, it's noted i may not have this privileges.Is there no solution to allow me to create my triggers?
No, there's no way to create triggers on our MySQL servers at the present time. This will become possible as we move to MySQL 5.1, but I don't have any timeline on that.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2089711
Server version: 5.1.39-log MySQL Server
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> CREATE TRIGGER activity_summary_bu
-> BEFORE UPDATE ON activity_summary FOR EACH ROW
-> SET NEW.activity_summary = 5;
ERROR 1142 (42000): TRIGGER command denied to user 'essnadmin'@'waratahs.dreamhost.com' for table 'activity_summary'
Any update on this? I need to create an audit trail for some of my tables, and would really prefer to do it via triggers, rather than manual inserts prior to updates.
In case it wasn't clear, I'll highlight it:
Server version: [size=xx-large]5.1.39[/size]-log MySQL Server
All I want is to be able to create on update triggers to insert into history tables