# SSL/TLS with built-in MySQL node?

**URL:** <https://discourse.nodered.org/t/ssl-tls-with-built-in-mysql-node/49343>\
**Category:** General\
**Created:** [4 August 2021 19:01 UTC](https://discourse.nodered.org/t/ssl-tls-with-built-in-mysql-node/49343 "2021-08-04T19:01:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![JDN](https://avatars.discourse-cdn.com/v4/letter/j/67e7ee/32.png) [@JDN](https://discourse.nodered.org/u/JDN)\
**Post date:** [4 August 2021 19:01 UTC](https://discourse.nodered.org/t/ssl-tls-with-built-in-mysql-node/49343/1 "2021-08-04T19:01:04Z")

</div>

Dear Community,

just a short question, has anyone established secure (ssl) communication between node-red and a MySQL instance?  
I am really struggling to find a solution to establish SSL connection between MySQL (running as a cloudSQL on gcloud) and node-red (latest versions of NodeJS and node-red).

I would prefer to use the built-in MySQL node. Has anybody established to modify the module in a way to work with SSL/TLS? Maybe modified the connection.js file of the module?

I have also tried to use the node-red-contrib-stackhero-mysql node, but cannot find a way to specify the path to the cert files.

Thanks in advance, cheers,  
David

---

<div class="post-metadata">

**Author:** ![JDN](https://avatars.discourse-cdn.com/v4/letter/j/67e7ee/32.png) [@JDN](https://discourse.nodered.org/u/JDN)\
**Post date:** [4 August 2021 19:41 UTC](https://discourse.nodered.org/t/ssl-tls-with-built-in-mysql-node/49343/2 "2021-08-04T19:41:59Z")

</div>

-user experience-  
Hi everybody, I am new to the forum and just thought I had to leave my most recent "thought about nodes"... I have been searching for hours to find a simple solution allowing secure MySQL database communication, so far without success. I think it would be awesome if there was a contribution that allowed us to simply activate a TLS option and add certificates (or the respective paths).

---

<div class="post-metadata">

**Author:** ![Paul-Reed](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/paul-reed/32/66906_2.png) [@Paul-Reed](https://discourse.nodered.org/u/Paul-Reed)\
**Post date:** [4 August 2021 20:19 UTC](https://discourse.nodered.org/t/ssl-tls-with-built-in-mysql-node/49343/3 "2021-08-04T20:19:18Z")

</div>

> [@JDN](#):
>
> I think it would be awesome if there was a contribution that allowed us to simply activate a TLS option and add certificates

Hi David (or is it Julian?), welcome to the forum.  
The topic [Tell us your thoughts about nodes](https://discourse.nodered.org/t/tell-us-your-thoughts-about-nodes/49085) is an invitation to complete a survey, and not to raise specific questions, especially as you have already raised this matter in this topic already.  
I've moved it here, to keep everything together.

Paul  
Moderator

---

<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:** [3 October 2021 19:01 UTC](https://discourse.nodered.org/t/ssl-tls-with-built-in-mysql-node/49343/4 "2021-10-03T19:01:59Z")

</div>

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