I'm trying not to enable using ssl for my connection, but I only have these 3 options in MySQL Workbench without 'No' and 'If Available' options.
I tried re-installing MySQL Workbench, but it doesn't work. What am I supposed to do now??
How to configure MySQL Workbench to not require SSL encryption
Viewed 16385
5 Answers
I had the same problem after upgrade to 8.0.27. Had no clue how to solve it.
I downgraded MySQL Workbench back to 8.0.19, and the 'No' and 'If Available' options came back.
Maybe they just want you to buy Navicat I guess.
Instead of downgrading you can also edit the file that stores the connection details with a different editor. This works for at least 8.0.27.
Open /home/.mysql/workbench/connections.xml.
Set the value to 0 for the following for each connection you want to use without SSL:
<value type="int" key="useSSL">0</value>
Note that you'd have to repeat the steps if you edit the connection with the workbench again afterwards.
MySQL Workbench Community version 8.0.28 is released and fix it - https://dev.mysql.com/downloads/workbench/
ssl certificates really guarantee a secure connection. But locally you shouldn't request a certificate..26 which by default makes use of ssl if it is available, otherwise in the new version it is a requirement.
here is the download link
Related