Bug #108525 Use SSL is set to "NO" but when trying to take dump from server it is failing
Submitted: 16 Sep 2022 13:30 Modified: 19 Sep 2022 12:53
Reporter: Piyush Keshari Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.30 OS:MacOS
Assigned to: CPU Architecture:ARM (M1 macbook air)

[16 Sep 2022 13:30] Piyush Keshari
Description:
I have set Use SSL to "NO" in SSL tab under connection settings and when trying to take dump getting this error:

mysqldump: Got error: 2026: SSL connection error: error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol when trying to connect

Extra information:

Below is the warning I get when I click on export button.

/opt/homebrew/bin/mysqldump is version 8.0.30, but the MySQL Server to be dumped has version 5.6.10.
Because the version of mysqldump is not the same as the server, some features may not be backed up properly.
It is recommended you upgrade or downgrade your local MySQL client programs, including mysqldump, to a version equal to or newer than that of the target server.
The path to the dump tool must then be set in Preferences -> Administrator -> Path to mysqldump Tool:

But this didn't cause issue in previous version of workbench.

How to repeat:
Server > Data Export > select the schema to export

Choose "Export to self contained file" option and specify the output location of the dump.

Also select "Create Dump in a Single Transaction (self-contained file only)" option then hit export.

Suggested fix:
Please fix this issue as I am not able to take dump due to this. My remote server doesn't support SSL I guess.
[19 Sep 2022 12:53] MySQL Verification Team
Hello Piyush Keshari,

Thank you for the bug report.
Imho this is duplicate of Bug #90924, please see Bug #90924 and follow the solution.

Regards,
Ashwini Patil