Log_bin_trust_function_creators error Solution

Log_bin_trust_function_creators error solution when mysql establishes a function locally or remotely or procedure, the preceding error is reported. The test result is that the value of log_bin_trust_function_creators is off:

Set global log_bin_trust_function_creators = 1;

 

But the permanent solution fails after restart.

In windows, my. ini [mysqld] And log_bin_trust_function_creators = 1 in linux/etc/my. cnf my. ini [mysqld] Plus log_bin_trust_function_creators = 1

 

Save and restart the server.