1

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?

citizen404
  • 1,485
  • 1
  • 10
  • 19

1 Answers1

1

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.

mkorszun
  • 4,461
  • 6
  • 28
  • 43
  • Thanks for your response! I suspected that the MySQLd addon is the only solution. But for my private non-commercial site 50 € / month for the micro plan is too much. So, I think I have to implement the trigger logic in the application layer as a workaround. – citizen404 Jun 19 '14 at 12:06