log_bin_trust_function_creators doesn't work in server 5.6.19 my.cnf


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 © 2009-2014 Percona LLC and/or its affiliates
Copyright © 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

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)



The option file version appears to be: log-bin-trust-function-creators with optional value of [=0|1]. Your issue is probably just the “s” on functions. =)


Hmm, it seems I need glasses, I was sure I cut&wasted it from the pxc config, but you’re right.
(Must have been in holiday mode :-/ )