How to configure MySQL Workbench to not require SSL encryption

Question

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

Solution 1

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.

Solution 2

You can go to the Advanced tab and type the following in the Others field:

useSSL=0

Solution 3

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.

Comments

[jialeee17]

Yes, that works for me too!!

[Justin N]

Thank you for this. Utterly ridiculous for Oracle to do this. I truly hope it's just a bug.

[VanDerNorth]

Reverting back to 8.0.26 was enough to get the options back.

[58k723f1]

On macos the location is /System/Volumes/Data/Users/<USER>/Library/Application Support/MySQL/Workbench/connections.xml

[João Pinho]

Works like a charm. Thanks!

[Yeray]

Works in 8.0.27. I've checked it against a MariaDB server. So there's no need to downgrade

[theking2]

This should be marked as answer. Will be fixed in 8.0.28

[theking2]

Will be fixed in 8.0.28

[Disturb]

The SSL tab doesn't show a "No SSL" option and this solution is not intuitive. Thank you, you saved me

[Bill K]

This works but it doesn't seem to keep the setting in that box, so the next time you enter that tab it's gone (and I think you need to re-enter it to get it to work again)

[mzk]

The file location in Windows 10 is C:\Users\USER-NAME\AppData\Roaming\MySQL\Workbench

[Wren]

This is perfect, just remember to keep an edited copy of the file handy as it may overwrite on close as well.