Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to configure MySQL Workbench to not require SSL encryption

Tags:

mysql

ssl

mysql-workbench

I'm trying not to enable using ssl for my connection, but I only have these 3 options in MySQL Workbench without 'No' and 'If Available' options. enter image description here

I tried re-installing MySQL Workbench, but it doesn't work. What am I supposed to do now??

like image 597
jialeee17 Avatar asked Oct 28 '21 02:10

jialeee17

People also ask

How do I disable SSL requirement in MySQL Workbench?

mysql/workbench/connections. xml , look for the connection that you want to disable ssl, and find <value type="int" key="useSSL">2</value> set it to 0, that will disable ssl for that connection.

How do I disable 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 can I connect to MySQL database without SSL?

You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. If you want to avoid the above MySQL warning, use the syntax mention in the beginning.

Do I need SSL for MySQL?

If, however, like you say that your MySQL server lives and is accessed only locally (never over WAN), you don't need SSL. If it's public facing or ever shares data over an insecure network, use SSL.

4 Answers

You can go to the Advanced tab and type the following in the Others field:

useSSL=0

like image 186
David Avatar answered Oct 26 '22 08:10

David

I had the same problem after upgrade to 8.0.27. Had no clue how to solve it.

I downgraded MySQL Workbench back to 8.0.19, and the 'No' and 'If Available' options came back.

Maybe they just want you to buy Navicat I guess.

like image 32
Nozomi Harry Avatar answered Oct 26 '22 09:10

Nozomi Harry

Instead of downgrading you can also edit the file that stores the connection details with a different editor. This works for at least 8.0.27.

Open /home/.mysql/workbench/connections.xml.

Set the value to 0 for the following for each connection you want to use without SSL:

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

Note that you'd have to repeat the steps if you edit the connection with the workbench again afterwards.

like image 4
Forage Avatar answered Oct 26 '22 09:10

Forage

MySQL Workbench Community version 8.0.28 is released and fix it - https://dev.mysql.com/downloads/workbench/

like image 1
Marco Thomazini Avatar answered Oct 26 '22 08:10

Marco Thomazini
Sign in to Comment

Related questions

Can Alter Table Engine = InnoDB be run on multiple tables at the same time?
Altering MySQL table to add foreign key constraint leads to errors
How to restart mysql server? [closed]
Select from multiple tables with laravel fluent query builder
Backup mysql database in xampp?
Mysql query to get count per months
MYSQL Round the datetime to 15 minute
Messaging system in php mysql
How to count the total number of rows in a ACF repeater output
Trouble with timezone with hibernate and MySQL
What does M,D mean in decimal(M,D) exactly?
Get percent of columns that completed by calculating null values
How do I set MySQL as the default database in Rails 3?
How to join two tables using a comma-separated-list in the join field
Create C# classes based of MySQL table
Using a DATE field as primary key of a date dimension with MySQL
How to get file extension of file as a result of sql query?
JOIN and GROUP_CONCAT with three tables
DATETIME select rows from last 2 hours
Laravel drop foreign Key in Migration

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!