Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do I disable SSL Requirement in MySQL Workbench?

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:
enter image description here

like image 248
dtan1117 Avatar asked Oct 29 '21 13:10

dtan1117


People also ask

How disable SSL in MySQL?

Disabling SSL in MySQL If your requirement is to completely turn off SSL on MySQL server instead of the default option of 'enabled, but optional mode', we can do the following: Delete the *. pem certificate and key files in the MySQL data directory. Start MySQL with SSL option turned off.

How do I turn off SSL mode?

In the Internet Options window on the Advanced tab, under Settings, scroll down to the Security section. In the Security section, locate the Use SSL and Use TLS options and uncheck Use SSL 3.0 and Use SSL 2.0.

How do I fix SSL connection error in MySQL?

right-click on the particular MySQL instance and select "Edit Connection" Select the "SSL" tab under Connection Method. Select the drop-down for the "Use SSL" and choose "If Available" instead of "Required". Click the "Test Connection" button at the lower right connection to make sure you can now connect without errors ...


1 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

like image 142
neXau Avatar answered Sep 17 '22 00:09

neXau