Node-red mysql connection refused

General
1

Hi, team. i am running mysql server(127.0.0.1) 8.0 on my local windows machine. My node-red is running on a remote gateway (192.168.1.1) .
my windows 10 computer is connected to the gateway through a ethernet cable. so i can use node-red in my chrome by putting the address http://192.168.1.1:1880/#. so can the node-red connect to my local database running in my pc?
Error: connect ECONNREFUSED 127.0.0.1:3306

image
image

2

This is a loopback address. It essentially means "this computer". Since node-red is on a different device, it cannot access mysql on a your computer using that IP. You will need to provide the IP of your computer. You will also likely need to open that port number in the windows firewall.

3

thans for reply. so i have changed the config to my ip of my computer and opened port 3306 of my computer. new error occured
image
image

4

Please post text as text (pictures cannot easily be searched)

What node-red-xxx-yyy node have you installed? What version is that node?

What version of NodeJS and Node-RED are you using?

5

I think you need to configure MySQL to allow the correct authentication type ( but I’m not at computer so can’t recall the details

6

Node-RED version: v0.15.2
Node.js version: v4.7.0
i have installed Node-RED / MYSQL 0.0.19 (2019-10)
image

7

oh my. That is all super old and 100% out of support.

Node version 18 LTS is the lowest version in support.

Node-RED v3.1.7 is the current version.

node-red-node-mysql current version is 2.0.0

I am not certain we can help unless you upgrade everything to latest versions.

8

for your reference, i have downgraded my mysql server from 8.0 to 5.6, it works ok now! Thank you @Steve-Mcl @dceejay

9

That's a surprising choice of solution.

One alternative, if you can't update your remote gateway (whatever that means), would be to buy a $15 Raspberry Pi Zero Two W and install Node-red on that.
You would get up-to-date Node-red, node.js & npm and could use node-red-node-mysql v2.0.0 and up-to-date MySQL.

Or even a Pi 5 with Node-red and Mariadb (= mysql).

10

Cool, now everything in your entire stack is out of support and likely vulnerable to bugs and CVEs. At least you are consistent :rofl:

2 Likes