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
eruzanski
Linode Staff
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