Clever Geek Handbook

Getting error while creating function in MySQL Heroku database

I have this error:

[Err] 1419 - you do not have SUPER privilege and binary registration is enabled (you can use a less secure variable log_bin_trust_function_creators

)

How can I avoid this error in Myok Heroku ClearDB database?

+3


source to share


1 answer


The reason you are facing this issue is due to the replication configuration that ClearDB uses in its clusters and the fact that you are running in a multi-tenant cluster. SUPER privileges reside in their dedicated clusters so you can create UDFs, stored procedures, and triggers. You can go to a dedicated cluster.



+6


source






More articles:


All Articles