How to connect remote MySQL server from digital ocean linux system

Question

Hey I am using mysql node js module to conect remote MySQL server it's work perfectly from my local system but when I try to access the MySQL remote server from digital ocean linux system it's send a error message connection time out how to fix this

Answer 1

Ekram Mallick

Port should be open and also you need to set inbound and outbound rules for the ip address which will allow you to access database from outside.

Answer 2

since it says time out its propably because of closed ports

Answer 3

Ok. I think you may want to check that the mysql remote port is open and so usable to the other server

since the request timed out, I dont think it never even reaches the mysql server.

although its never a good idea to connect to databases remotely

Answer 4

Toni this MySQL server is hosted in different hosting I want to connect it from my digital ocean linux system with node js

Answer 5

Bro I think you don't get it I clearly mentioned that I am able to connect the MySQL server from my local environment but when I try to access it from a linux system then the problem occurs I used the same node js code and module