When I try to create a trigger for my mysqls database addon on cloudcontrol.com I get the following error:
ERROR 1419 (HY000): You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)
So, is there really no way for me to use triggers? That's frustrating. Any workarounds?
Enabling trigger is only possible with the MySQLd addon, for this we have to enable the log_bin_trust_function_creators. Be aware that this can cause some problems with insecure triggers. You can find more information in the mysql documentation.