I have a local developer environment running MySQL server 5.7.27. I used MySQL Workbench 6.3.10 (this is the latest version AFAIK before 8.0 appeared) without any problem. However when I upgrade to MySQL Workbench 8.0.18 and try to connect to the exact same local server, I get an error:
Failed to Connect to MySQL at 127.0.0.1:3306 with user root SSL connection error: error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol
This is not a problem with root access since I can connect to the exact same server without any configuration change whatsoever with the 6.3.10 workbench. Also not a problem with 127.0.0.1 I believe for the same reason.
Maybe it's something with OpenSSL? But I cannot see enough info in logs. Most I got is
[Note] Bad handshake in the
/var/log/mysql/error/log. Consequently, if I turn off the SSL connection (forcing unencrypted connection), the Workbench can connect. So it's clearly some mismatch between Server 5.7.2x and the 8.x Workbench, but why?
I installed the 18.04 LTS version of the Workbench 8.0.18, and let's say my Ubuntu is like that as well (it's a derivative).
unsupported protocolerror. When I disable SSL I am able to connnect.