# Node-red-node-mysql ER\_SECURE\_TRANSPORT\_REQUIRED

**URL:** <https://discourse.nodered.org/t/node-red-node-mysql-er-secure-transport-required/38926>\
**Category:** General\
**Created:** [10 January 2021 21:02 UTC](https://discourse.nodered.org/t/node-red-node-mysql-er-secure-transport-required/38926 "2021-01-10T21:02:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![luismiguelbp](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/luismiguelbp/32/35126_2.png) [@luismiguelbp](https://discourse.nodered.org/u/luismiguelbp)\
**Post date:** [10 January 2021 21:02 UTC](https://discourse.nodered.org/t/node-red-node-mysql-er-secure-transport-required/38926/1 "2021-01-10T21:02:52Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [11 March 2021 21:03 UTC](https://discourse.nodered.org/t/node-red-node-mysql-er-secure-transport-required/38926/2 "2021-03-11T21:03:01Z")

</div>

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