Problem connected MySQL

General
1

I have problem connected with my database server
I use QNAP storage
My Node Red installed in Docker
MariaDb in sytem Qnap
How config my flow mysql - IP adress
my flow answer me --> Error: connect ECONNREFUSED 127.0.0.1:3307

MariaDB config
Server: 127.0.0.1 via TCP/IP
Port: 3307
Server type: MariaDB
Server connection: SSL is not being used Documentation
Server version: 10.5.8-MariaDB-log - MariaDB Server
Protocol version: 10
User: root@localhost
Server charset: cp1252 West European (latin1)

switch
switch991×366 39 KB

2

Hi,

I'm not even going to talk about the virtual network or Docker config here. Each of those introduce another level of complexity.

Many versions of MYSQL need additional configuration / security settings to allow a connection via TCP/IP from a different machine. A different machine is defined as a different IP address.

Also: Can you ping from one machine to the other?

Cheers,

Paul

3

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