Node JS remote mysql database connection error

Question

I am relatively new to the Node JS, and I have been trying to connect to a remote mysql server, but I have been unable to do so. I have been looking for the solutions on here but most of them are for localhost. Here is my code:

var mysql = require('mysql');
var con = mysql.createConnection({
  host: "###.ipagemysql.com",
  user: "user",
  password: "mypass",
  database: "mydb",
  debug: true
});

con.connect(function(err) {
  if (err) throw err;
  console.log("Connected!");

});

I am getting the error below:

Error: connect ECONNREFUSED 103.224.212.250:3306
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1117:14)

UPDATE: I tried using a different MySQL server and that works fine. Could it be because iPage is blocking the connection because it is coming from a foreign machine? Is this something that can be configured in phpmyadmin?

have you checked the server connectivity on that port from your machine. try "telnet" to check if the connection is available. — Muhammad Omar ElShourbagy
– Muhammad Omar ElShourbagy, Commented Mar 18, 2019 at 7:34

Duc Vu · Accepted Answer · 2019-03-18 07:42:17Z

1

Possibly port 3306 is not accessible from the application. You can try telnet to server 103.224.212.250:3306 to see if it is opened or not.

answered Mar 18, 2019 at 7:42

Duc Vu

951 gold badge1 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Aiden Over a year ago

It appears it is in fact closed. I tried using a different mysql server and that works fine. Could it be because iPage is blocking the connection because it is coming from a foreign machine? Is this something that can be configured in phpmyadmin?

Duc Vu Over a year ago

Since you has not give more details on how you currently connect to you db server. There are 2 possibility: user config and server config. For user config, it may be declared as 'user'@'localhost', so that user is only accessible if it is in the same host with mysql server. Server config is if mysql server open port 3306 for accessing from outside, i.e firewall

Collectives™ on Stack Overflow

Node JS remote mysql database connection error

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related