Bug #105429 Server Connection manager enforces SSL encryption
Submitted: 2 Nov 2021 15:13 Modified: 3 Nov 2021 7:45
Reporter: Dimitar Nikov Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.27 OS:Any
Assigned to: CPU Architecture:Any
Tags: SSL

[2 Nov 2021 15:13] Dimitar Nikov
Description:
"Use SSL" drop-down under SSL Tab in Server Connection Manager enforces SSL encryption.
Making SSL encryption mandatory when adding new and/or editing existing connections with no-SSL enabled servers renders Workbench unusable.

Possible workaround: Edit the `connection.xml` file and change `<value type="int" key="useSSL">2</value>` to `<value type="int" key="useSSL">0</value>`. One-liner for Linux

sed -i.bak -e 's/useSSL">2</useSSL">0</g' ~/.mysql/workbench/connections.xml

For other OSes - please put the correct path to the file.

How to repeat:
1. Create new or edit existing connection
2. Navigate to "SSL" tab
3. Try to chose anything but SSL encryption in drop-down for "Use SSL"

Suggested fix:
Add an empty option in drop-down menu for "Use SSL" drop-down in SSL tab.
[2 Nov 2021 15:13] Dimitar Nikov
Use SSL Drop-down in SSL Tab

Attachment: Use-SSL-MySQL-Workbench.png (image/png, text), 57.49 KiB.

[3 Nov 2021 4:24] MySQL Verification Team
Hello Dimitar Nikov,

Thank you for the bug report.
Imho this is duplicate of Bug #105327, please see Bug #105327.

Regards,
Ashwini Patil
[3 Nov 2021 7:45] Dimitar Nikov
Hi Ashwini,
you are right, please consider closing this one.

I'll put my workaround in #105327.