Bug #105327 Test Connection in Workbench fails since SSL required
Submitted: 26 Oct 12:23 Modified: 26 Oct 12:53
Reporter: Andrew Watkins Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S2 (Serious)
Version:8.0.27 OS:Any
Assigned to: CPU Architecture:Any
Tags: SSL, test, workbench

[26 Oct 12:23] Andrew Watkins
Description:
With latest version 8.0.27 SSL connection is required (with versions 8.0.26 and below) and the old "if required" and "No" have gone from "Use SSL"

The connection still works but "Test Connection" fails
SSL connection error: SSLis required but the server doesn't support it

How to repeat:
Create a connection in Manage Server Connections
Leave SSL tab option empty
Use SSL: Required

Test Connection fails

Note: Server has no SSL 

Suggested fix:
Bring back the "if required" and "No" options in "USE SSL"
[26 Oct 12:53] MySQL Verification Team
Hello Andrew Watkins,

Thank you for the report and feedback.

regards,
Umesh
[27 Oct 11:32] MySQL Verification Team
Bug #105340 marked as duplicate of this one
[27 Oct 12:42] Francisco Granja
In my case not only the test but connection itself becomes unusable. It also happens with any previous connection that you modify.
[28 Oct 12:35] MySQL Verification Team
Bug #105360 marked as duplicate of this one
[3 Nov 4:25] MySQL Verification Team
Bug #105429 marked as duplicate of this one.
[3 Nov 7:48] Dimitar Nikov
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 you have to point to correct file name, as of:
- Windows - %AppData%\MySQL\Workbench\connections.xml
- macOS  - ~/Library/Application Support/MySQL/Workbench/connections.xml
[4 Nov 17:05] MySQL Verification Team
Bug #105460 marked as duplicate of this one
[9 Nov 13:23] MySQL Verification Team
Bug #10550 marked as duplicate of this one
[13 Nov 12:28] shoujun li
In my case mysql-workbench-community-8.0.27-macos-x86_64.dmg has this issue too.