Configure MySQL Workbench to not require SSL encryption
If you get the MySQL Workbench error of "SSL connection error: SSL is required but the server doesn't support it" then you likely just need to change a setting that's defined within the MySQL Connections within MySQL Workbench.
From the MySQL Connections screen click on the little wrench icon to the right to bring up Manage Server Connections window.
From the Manage Server Connections window click on the "MySQL Connection" that is giving you this error, then from the SSL tab you will want to ensure the Use SSL field has a value of If available so it only uses SSL if it's available or else it'll connect without SSL encryption.
Press the Test Connection option from the bottom of the Manage Server Connections window after you make the to confirm the error goes away.
Update: Firstly, downgrading to version
8.0.26 brings back the
If available options for the
Use SSL field. They're removed in version
8.0.27. You can find older versions here of MySQL Workbench here: MySQL Product Archives
If you continue to have trouble you might set the Use SSL field to a value of No and also ensure all the SSL fields below that are blank and then test the connection again.
localhostis always the computer the command is running on, so I'm not certain that encryption serves much purpose. SSL requires a certificate be installed on the server in question. See if you can modify the configuration in mysqlworkbench to connect to the server without encryption/SSL.