Node-red-node-mysql ER_SECURE_TRANSPORT_REQUIRED

General
1

Hi, can anyone help,
I'm trying to connect to a MySQL instance that has SSL configured, and receive this error message on the Node node-red-node-mysql.

"Error: ER_SECURE_TRANSPORT_REQUIRED: Connections using insecure transport are prohibited while --require_secure_transport=ON."

I want to connect to the MySQL instance but using SSL, you know if this node supports SSL connections ?

mysql Ver 8.0.22-0ubuntu0.20.04.3 for Linux on x86_64 ((Ubuntu))
In /etc/mysql/@my.cnf I have this settings
[mysqld]
require_secure_transport = ON
bind-address = 0.0.0.0

(self signed certificate)

Best regards, Luis Miguel BP.

2

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.