CREATE TRIGGER without SUPER privilege on cloudcontrol.com

1
votes

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?

1
mysqlcloudcontrol

1 Answers

1
votes

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.