1

Everytime my rackspace server restarts because of some maintenance or an outage, all of my mysql functions stop working due to this deterministic error.

To fix this, I have to manually pull up the database and run SET GLOBAL log_bin_trust_function_creators = 1;

is there anyway to have this set by default so my sql calls don't break on restart?

Sean Clark
  • 111
  • 2
  • Either fix your functions (add the proper keywords to the definition) or fix your config - add log_bin_trust_function_creators = 1 to my.cnf under the [mysqld] section. – jkavalik Jun 27 '16 at 18:25
  • @jkavalik if you post that as the answer, i'll mark it. Thanks so much! – Sean Clark Jun 27 '16 at 22:19

0 Answers0