How to disable ssl in database mysql?

The default value is enabled
port = 3306
ssl = ENABLED,
is it possible to turn SSL off? cause when I try to connect to the database I get the error:
Connections using insecure transport are prohibited while --require_secure_transport=ON.

2 Replies

Hi there,

If this is with regard to a Linode Managed Database, you are able to change this flag yourself while logged in to your MySQL database:

SET GLOBAL require_secure_transport=OFF;

Using SET GLOBAL will enable bypassing SSL connections until the next reboot; to write the change to the mysqld-auto.cnf file so that the setting persists after a server reboot, use SET PERSIST instead:

SET PERSIST require_secure_transport=OFF;

Kindest regards,
Eric

I get an error when running: SET PERSIST require_secure_transport=ON;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'require_secure_transport=ON' at line 1

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct