Can we create triggers in our MySQL5 databases? I just tried and got this error message:
Access denied; you need the SUPER privilege for this operation
The SQL code I used to generate this error is (I actually want it to insert into several other tables, too, and only do so under certain conditions- so this is a simpler version of the trigger):
TRIGGER NewGameChar after Insert
ON GREntName FOR EACH ROW
Insert Into GRGameChar (EntId) Values (New.EnNameId);
I tried exploring the control panel, searching the forums and wiki for info on MySQL triggers or privilege levels, or just skimming through the posts, and I don’t see anything on the topic.
Is this something we cannot do due to the shared hosting setup? If so, is it possible to have a custom trigger implemented upon request? I can understand if triggers are not measured with other types of queries and this might be a billing concern. Perhaps this could be solved by having the trigger call a stored procedure or something?
Any guidance on this is greatly appreciated. I really like being able to set up triggers.