Related

Product Now Available: Managed MySQL Databases Product
Managed MySQL, Redis, Postgres on DigitalOcean Product
Cannot import a DB from a shared hosting at Bluehost to a DB on Vesta CP Question Question
MySQL Managed Database Question Question

Question

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

Posted June 15, 2020 380 views
MySQLDatabases

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?
Thanks
Chariya

Add a comment
cpeters5
By:
cpeters5
Add a comment

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.

×
1 answer
KFSys June 15, 2020

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.

Regards,
KDSys

Reply Report
  • cpeters5 June 16, 2020

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

    Reply Report
    • KFSys June 16, 2020

      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,

      Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help