Not the answer you need?
Register and ask your own question!

log_bin_trust_function_creators doesn't work in server 5.6.19 my.cnf

HubertusKrogmannHubertusKrogmann ContributorInactive User Role Contributor
Hello

I have set this option on a 5.6.15 PXC (customer needs it) but could not set it on the 5.6.19 async slaves which replicates from the pxc:

I tried some variations in the my.cnf:

2014-08-12 11:58:17 31360 [ERROR] /usr/sbin/mysqld: unknown option '--log_bin_trust_functions_creators'
2014-08-12 12:00:50 32329 [ERROR] /usr/sbin/mysqld: unknown variable 'log_bin_trust_functions_creators=1'
2014-08-12 12:06:24 3705 [ERROR] /usr/sbin/mysqld: unknown variable 'log-bin-trust-functions-creators=1'
2014-08-12 12:09:45 4710 [ERROR] /usr/sbin/mysqld: unknown option '--log-bin-trust-functions-creators'
2014-08-12 12:10:54 5633 [ERROR] /usr/sbin/mysqld: unknown option '--log_bin_trust_functions_creators'
2014-08-12 12:12:20 7383 [ERROR] /usr/sbin/mysqld: unknown variable 'log_bin_trust_functions_creators=ON'
2014-08-12 12:12:56 8283 [ERROR] /usr/sbin/mysqld: unknown variable 'log_bin_trust_functions_creators=ON'

seting it dynamically after restart without the my.cnf parameter works:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 29
Server version: 5.6.19-67.0-log Percona Server (GPL), Release 67.0, Revision 618

Copyright (c) 2009-2014 Percona LLC and/or its affiliates
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> set global log_bin_trust_function_creators = 1;
Query OK, 0 rows affected (0.00 sec)

mysql>

Bug?

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.