Log_bin_trust_function_creators _ MySQL-mysql tutorial

Log_bin_trust_function_creators error solving bitsCN.com

Log_bin_trust_function_creators error solution

The preceding error is reported when mysql establishes a function or procedure locally or remotely.

The test result is that the value of log_bin_trust_function_creators is off.

Settings:

Set global log_bin_trust_function_creators = 1;

But it becomes invalid after restart.

Permanent Solution

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.

BitsCN.com