Database connection from a server fail with [ERROR] unknown variable 'log_bin_trust_function_creators=1'.

Posted June 15, 2020 1.1k views

I just created a database cluster with SSL connect and assigned the IP address of my server as trusted IP. When I tried to connect using the provided flag I got the unknown variable error

mysql: [ERROR] unknown variable ‘logbintrustfunctioncreators=1’.

How do I resolve this?

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
1 answer

Hi @cpeters5,

Can you please confirm how exactly are you trying to connect, what sofware are you using, from where you are connecting to your MySQL, are you using a Managed Database?

It seems like the software you are connecting from, doesn’t recognize this option which is strange. Most probably it’s an older version.


  • Thanks for your response.
    The problem is solved. I tried reinstalling mysql in hte client droplets and somehow the connection was successful.

    • Hi @cpeters5,

      Thanks for clarifying, I’m glad to hear that!

      Most probably the version was too low so reinstalling it, you installed a newer one which supported this option,