[Solved] MySQL Workbench 8.0 Error: SSL connection error: SSL is required but the server doesn‘t support it

When MySQL workbench 8.0 connects to the database, it prompts:

The solution is as follows.

1、Create a connection in workbench first, close workbench
2. Open C:\Users[username]\AppData\Roaming\MySQL\Workbench\connections.xml, find the information about this connection, then change <value type=”int” key=”useSSL”>2</value> to <value type=”int” key=”useSSL”>1</value
3. Reopen workbench and double click on the connection information to connect to the database

 

MySQL Workbench 8.0 has ssl connection turned on by default, change the value to 1 to turn off SSL connection

Similar Posts: