# NODE-RED MYSQL NODE connection refused

**URL:** https://discourse.nodered.org/t/node-red-mysql-node-connection-refused/4147
**Category:** General
**Created:** [20 October 2018 20:20 UTC](https://discourse.nodered.org/t/node-red-mysql-node-connection-refused/4147 "2018-10-20T20:20:13Z")
**Posts on this page:** 8
**Page:** 2

<div class="post-metadata">

### Author: ![shrickus](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/shrickus/32/517_2.png) [@shrickus](https://discourse.nodered.org/u/shrickus)
#### Post date: [7 January 2019 15:45 UTC](https://discourse.nodered.org/t/node-red-mysql-node-connection-refused/4147/21 "2019-01-07T15:45:57Z")

</div>

So, are you trying to get your cloud-based node-red server to connect to the mysql database on your local machine? If so, that will not work...

---

<div class="post-metadata">

### Author: ![Tefita](https://avatars.discourse-cdn.com/v4/letter/t/a8b319/32.png) [@Tefita](https://discourse.nodered.org/u/Tefita)
#### Post date: [7 January 2019 16:55 UTC](https://discourse.nodered.org/t/node-red-mysql-node-connection-refused/4147/22 "2019-01-07T16:55:19Z")

</div>

Thank you for responding and is there any alternative to this problem?

---

<div class="post-metadata">

### Author: ![shrickus](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/shrickus/32/517_2.png) [@shrickus](https://discourse.nodered.org/u/shrickus)
#### Post date: [7 January 2019 16:59 UTC](https://discourse.nodered.org/t/node-red-mysql-node-connection-refused/4147/23 "2019-01-07T16:59:41Z")

</div>

Yes, your database will have to be somewhere that is "reachable" from the node-red server.  
So you can either run node-red on your local machine, or put the database in the cloud, too.

I'm glad to see that your local computer is NOT accessible from the internet, because that would be  
"bad, Ray... very, very bad"

---

<div class="post-metadata">

### Author: ![Tefita](https://avatars.discourse-cdn.com/v4/letter/t/a8b319/32.png) [@Tefita](https://discourse.nodered.org/u/Tefita)
#### Post date: [8 January 2019 14:18 UTC](https://discourse.nodered.org/t/node-red-mysql-node-connection-refused/4147/24 "2019-01-08T14:18:06Z")

</div>

Thank you for answering my question, now I am in a serious problem.

---

<div class="post-metadata">

### Author: ![Tatea42](https://avatars.discourse-cdn.com/v4/letter/t/b5e925/32.png) [@Tatea42](https://discourse.nodered.org/u/Tatea42)
#### Post date: [2 March 2020 04:13 UTC](https://discourse.nodered.org/t/node-red-mysql-node-connection-refused/4147/25 "2020-03-02T04:13:33Z")

</div>

> [@Trying\_to\_learn](#):
>
> mysqld.cnf

how to connect mysql on Node-red why i alwyas can't connect how can i get the ip dan get password please help me

---

<div class="post-metadata">

### Author: ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [2 March 2020 07:23 UTC](https://discourse.nodered.org/t/node-red-mysql-node-connection-refused/4147/26 "2020-03-02T07:23:05Z")

</div>

Rather than replying to a year old thread that is about a problem that is probably not the same as yours it would be better to start a new thread. When you do that you need to tell us a lot more information about your setup. Things like where the mysql server is running, what OSs you are using on the various machines involved, whether you can connect to the mysql server using another mysql client such as the command line client. Also what versions of node red and nodejs you are using and which mysql node you are using (possibly node-red-contrib-something)?

---

<div class="post-metadata">

### Author: ![ravi071213](https://avatars.discourse-cdn.com/v4/letter/r/b9bd4f/32.png) [@ravi071213](https://discourse.nodered.org/u/ravi071213)
#### Post date: [16 February 2021 15:36 UTC](https://discourse.nodered.org/t/node-red-mysql-node-connection-refused/4147/28 "2021-02-16T15:36:51Z")

</div>

/etc/mysql/conf.d/mysql.cnf

---

<div class="post-metadata">

### Author: ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)
#### Post date: [16 February 2021 15:42 UTC](https://discourse.nodered.org/t/node-red-mysql-node-connection-refused/4147/29 "2021-02-16T15:42:45Z")

</div>



[Previous page](https://discourse.nodered.org/t/node-red-mysql-node-connection-refused/4147.md?page=1)
