It seems that SSL connection is required to use MySQL Workbench, and I don't think this is the case with previous versions.
I remember SSL connections used to be optional. After I updated it, all options are locked to require SSL.
How do I bypass this? I'm just a student and setting up SSL is out of my reach.
CodePudding user response:
I don't know if it may be the right approach for you, but what I did is downgrade my version of MySQL Workbench to 6.3 and uninstalled the previous version and it will then give you the "if available" option for SSL. As you are right, it is not the case for previous versions, however you do lose a few more modern features in the process.
https://downloads.mysql.com/archives/workbench/
CodePudding user response:
I solved this by editing the connections.xml configuration file.
Under ~/.mysql/workbench/connections.xml I searched for the connection name and changed
<value type="int" key="useSSL">2</value>
to
<value type="int" key="useSSL">1</value>