Trying to access a remote MySQL database

General
1

I'm trying to set-up access (for my IoT students) to a remote MySQL database that has been recording readings from our weather station.
I've written the NR flow and got everything working from my home using node-red-node-mysql.
Everything works fine - database updates and I can access it fine.
Also my friend in the USA can access the database just fine as well.

The problem comes when I try to do this via the school's network.
I can ping the MySQL server from the IT Room, so this sort of indicates there is a route to the server.
I've entered the various IP addresses into the Remote MySQL settings with my ISP to grant remote access.

I'm sure this is a networking problem with the school's network, but as I'm not familar with the intricacies of corporate networking I'm at a bit of a loss as to what to try next.
The error message I get in a debug node (at school) is "Error: Pool is closed" and "Database is not connected".

Any suggestions as to what I could check or try, would be appreciated.

2

Is the port on the server accessible via your network. I think it’s 3306 by default. Maybe a tool like nmap will help test it end to end

3

Thanks Dave - yes it is port-3306.
I'll ask the IT people to check it.

4

nmap -p 3306 ip-of-server

Should do it from your client end

5

Thanks Dave - when I said the IT people, I meant the IT people at the school.

I've just run the 'nmap' command on one of my RPi(es) and can see what the results look like - thanks.

6

I try to config mysql node to connect my database which located at remote host ,but it doesn't connect. may i have your project flow ,for checking my nodes configurations ?

7

You have replied to a very old thread. A lot has changed since then. Please start a new thread and give us a lot more information about your problem. What versions of node red and nodejs are you using? What OS? What error are you seeing? Also, can you access the database from the machine running node red using something like the mysql command line client?

I will close this thread.