mysqlherokucleardb

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

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?

Solution

  • 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.