Has anyone used MySql over SSH?

Wappler General How To
#1

For me direct DB connect test is working fine, it also shows all the tables correctly while creating the API, but while trying to run, it throws
“ECONNREFUSED”,“message”:“connect ECONNREFUSED 127.0.0.1:3306”.
Thanks in advance.!
As per the client, it can be accessed on local host at given port and given IP. I tried accessing it with my private key.
Screenshot 2023-08-10 at 3.12.49 PM|431x500

1 Like
#2

I found a post about this from 2019, but its for PHP server model. Server side connection to mysql via ssh

What you are looking for is on NodeJS. @patrick any ideas? I tried identifying the issue here, but it seems DB Manager is able to connect correctly, but Globals DB connection fails when running SA on browser.

1 Like
#3

Looking at a post(Has anyone used MySql over SSH?) I think @Dave s solution worked, have a look if he can help.