Getting Error while I Create a Function in Heroku MySQL Database Addin

3
votes

I've got this error:

[Err] 1419 - 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)

How can I get avoid getting this error in Heroku ClearDB MySQL database?

1
mysqlherokucleardb
I'm having the same issue, were you able to resolve? I am considering migrating to Heroku Postgres because of this but still not 100% sure I'll be able to create stored procedures and triggers on their affordable plans either... – Cameron Askew

1 Answers

6
votes

The reason you're running into this issue is because of the replication configuration that ClearDB uses in their clusters and the fact that you're on a multi-tenant cluster. SUPER privileges are on their dedicated clusters so that you can create UDFs, stored procedures and triggers. You can upgrade to dedicated cluster.