How do I disable the SSL requirement in MySQL Workbench?

user_17280346 0
Viewed 35729

It seems that an 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:

Enter image description here

mysql-workbench ssl mysql
6 Answers

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

user_176122170

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>
user_50828560

MySQL Workbench has released 8.0.28

It solves this bug. Wow. I am happy.

In Mac OS X there is this issue.

My version is mysql-workbench-community-8.0.27-macos-x86_64.dmg.

I have downgraded to mysql-workbench-community-8.0.26-macos-x86_64.dmg, and it has solved it.

This issue has been reported to the MySQL team. See Test Connection in Workbench fails since SSL required (Bug #105327).

In the bug report, the development team replies that this issue will be fixed in 8.0.28.

Someone may be waiting for the fix, but check for the newest version on the download page.

user_67354950

I found this solution on Stack Exchange and worked for me just fine on Windows 10. This is the original post: MySQL Workbench: "ssl is required but the server doesn't support it".

Look for the fehrlich's answer. 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

user_150922870

I don't know if it may be the right approach for you, but I downgraded my version of MySQL Workbench to 6.3 and uninstalled the previous version. 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.

MySQL Product Archives

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

user_88088180

I am using MySQL server 5.6. Uninstall and install MySQL Workbench 8. It's working.

Enter image description here

Admin1
Related