# Error: connect ECONNREFUSED while connecting to MYSQL

**URL:** <https://discourse.nodered.org/t/error-connect-econnrefused-while-connecting-to-mysql/13743>\
**Category:** General\
**Created:** [27 July 2019 09:12 UTC](https://discourse.nodered.org/t/error-connect-econnrefused-while-connecting-to-mysql/13743 "2019-07-27T09:12:47Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![anisha](https://avatars.discourse-cdn.com/v4/letter/a/8dc957/32.png) [@anisha](https://discourse.nodered.org/u/anisha)\
**Post date:** [27 July 2019 09:12 UTC](https://discourse.nodered.org/t/error-connect-econnrefused-while-connecting-to-mysql/13743/1 "2019-07-27T09:12:47Z")

</div>

![Capture](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/a/acfa4b305124cc2e4c94dfd267238c9859242e1d.jpeg)  
I am using IOT 2040 connect with energy meter running in node-red server it's perfectly working but I want to pass this data to local server MYSQL  
Give me a solution please

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [27 July 2019 09:16 UTC](https://discourse.nodered.org/t/error-connect-econnrefused-while-connecting-to-mysql/13743/2 "2019-07-27T09:16:32Z")

</div>

You need to connect to the database. Are you really running MYSQL on an IOT2040 device?

See [https://stackoverflow.com/questions/7864276/cannot-connect-to-database-server-mysql-workbench](https://stackoverflow.com/questions/7864276/cannot-connect-to-database-server-mysql-workbench) for some problem solving steps.

---

<div class="post-metadata">

**Author:** ![dynamicdave](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dynamicdave/32/96_2.png) [@dynamicdave](https://discourse.nodered.org/u/dynamicdave)\
**Post date:** [27 July 2019 10:12 UTC](https://discourse.nodered.org/t/error-connect-econnrefused-while-connecting-to-mysql/13743/3 "2019-07-27T10:12:04Z")

</div>

I've seen that error in the past.  
In my case I was trying to access a remote MySQL dB (not a local one).  
I ended-up having to enter my external IP in my ISP's 'grant remote access' setting in the cPanel.

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [27 July 2019 11:25 UTC](https://discourse.nodered.org/t/error-connect-econnrefused-while-connecting-to-mysql/13743/4 "2019-07-27T11:25:15Z")

</div>

is NR running on the same macine as MySQL? By setting the IP to 127.0.0.1 (which is the local loopback) that tells NR to attempt to connect to MySQL on the same machine.

Try putting in the IP of the machine running MySQL and see what happens.

---

<div class="post-metadata">

**Author:** ![anisha](https://avatars.discourse-cdn.com/v4/letter/a/8dc957/32.png) [@anisha](https://discourse.nodered.org/u/anisha)\
**Post date:** [27 July 2019 12:05 UTC](https://discourse.nodered.org/t/error-connect-econnrefused-while-connecting-to-mysql/13743/5 "2019-07-27T12:05:13Z")

</div>

Connect to database

---

<div class="post-metadata">

**Author:** ![dynamicdave](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dynamicdave/32/96_2.png) [@dynamicdave](https://discourse.nodered.org/u/dynamicdave)\
**Post date:** [27 July 2019 16:28 UTC](https://discourse.nodered.org/t/error-connect-econnrefused-while-connecting-to-mysql/13743/6 "2019-07-27T16:28:14Z")

</div>

Can you share what you did to get it to connect to the dB???