How do I disable SSL Requirement in MySQL Workbench?

Solution 1:

Here is the correct solution for version +8.0.x. When the program starts, the edited configuration files are changed again.

Therefore, you need to add useSSL=1 in advanced.

ssl req

Solution 2:

I solved this by editing the connections.xml configuration file.

Under ~/.mysql/workbench/connections.xml I searched for the connection name and changed

<value type="int" key="useSSL">2</value>

<value type="int" key="useSSL">1</value>

Solution 3:

I found this solution on Stack Exchange and worked for me just fine on Windows 10. This is the original post: https://dba.stackexchange.com/questions/199154/mysql-workbench-ssl-is-required-but-the-server-doesnt-support-it.

Look for the 'fehrlich' answer and please, give the credits. I will describe it here as in the original post.:

You can bring back the old SSL options in 8.0.27:

Close MySQL Workbench
Go to you MySQL Workbench install folder (p.e. C:\Program Files\MySQL\MySQL Workbench 8.0 CE)
open the file modules/data/mysql_rdbms_info.xml
replace all occurrences of
">2|Require,3|Require and Verify CA,4|Require and Verify Identity"
with ">0|No,1|If available,2|Require,3|Require and Verify CA,4|Require and Verify Identity"

Now you have the old options back.

Original image

Solution 4:

MySQL Workbench has release 8.0.28,slove this bug, wow, happy.

====
In macos also has this issue. My version is mysql-workbench-community-8.0.27-macos-x86_64.dmg

I have downgrade to mysql-workbench-community-8.0.26-macos-x86_64.dmg and solve it.

===
this issue has been report to mysql team,see

https://bugs.mysql.com/bug.php?id=105327
===2021-12-05 Edit
In the bug report,the develop team reply this issue will be fixed in 8.0.28. ===2021-12-08 Edit
Someone maybe waiting for the fix , so I put the download page link here, so we can check the newest version quickly. https://dev.mysql.com/downloads/workbench/