How do I disable SSL Requirement in MySQL Workbench?

Question

It seems that SSL connection is required to use MySQL Workbench, and I don't think this is the case with previous versions.

I remember SSL connections used to be optional. After I updated it, all options are locked to require SSL.

How do I bypass this? I'm just a student and setting up SSL is out of my reach.

Screenshot:

Solution 1

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>

to

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

Solution 2

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.

Solution 3

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/

Solution 4

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 5

I don't know if it may be the right approach for you, but what I did is downgrade my version of MySQL Workbench to 6.3 and uninstalled the previous version and it will then give you the "if available" option for SSL. As you are right, it is not the case for previous versions, however you do lose a few more modern features in the process.

https://downloads.mysql.com/archives/workbench/

Another solution as well is to connect to connect to the database in 6.3 and since the configuration saves are in same location, upgrade to 8.0 where it will still have the old configuration file and won't use SSL due to backwards compatibility.

View more solutions

Comments

[DARKGuy]

Thanks, I had to do this too. I don't know what's going on in Workbench's developers head but it's definitely a mess.

[DARKGuy]

FYI: For Windows, the path is C:\Users\<your username>\AppData\Roaming\MySQL\Workbench\connections.xml

[theking2]

or Win+R and copy paste %AppData%\MySQL\Workbench\connections.xml

[Ti Hausmann]

8.0.26 still has the "no" and "if available" option, so no need to go as far as 6.3.

[Abhijith]

Can confirm this works on Windows. But I had to set connections.xml to read-only via file-properties to get this to work. Workbench was rewriting the useSSL property every time I restarted workbench.

[Marko Bonaci]

Same here, the option No appeared after I downgraded to 8.0.26.

[Marko Bonaci]

This didn't work for me on wsl2 on Win11 with Ubuntu20.04, but @lixiaoshi's comment worked (downgrade to 8.0.26.

[Guanghui Li]

Thanks for the easy and simple solution

[Anu]

Seems like this should be the answer

[jgarcias]

This answer works for the current session only. The next time you open the MySQL Workbench you will have to type it again. The answer given by @Fez is the best because adds the "No" option to your "Use SSL" dropdown list and once chosen it remains selected.

[jgarcias]

This is the best answer so far, because it adds the "No" option to the "Use SSL" dropdown list and the value remains selected.

[Skepller]

Can confirm! It's available, upgraded to "8.0.28" on Ubuntu 20.04 and the "If Available" option on SSL is back. Just updating should fix the issue now.