Announcement

Announcement Module
Collapse
No announcement yet.

log_bin_trust_function_creators doesn't work in server 5.6.19 my.cnf

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • log_bin_trust_function_creators doesn't work in server 5.6.19 my.cnf

    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?

  • #2
    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. =)

    http://dev.mysql.com/doc/refman/5.6/...ction-creators

    Comment


    • #3
      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 :-/ )
      Thanks

      Comment

      Working...
      X