MySQL Connection on Node.JS

Question

I have a problem when I try to connect to a MySQL database hosted by OVH on NodeJS server. Here is the code :

var mysql      = require('mysql');

var connection = mysql.createConnection({
  host     : 'my_ip',
  port     : '3306',
  user     : 'my_user',
  password : 'my_pass',
  connectTimeout : 10000
});

connection.connect(function(err) {
  if (err) {
    console.error('error connecting: ' + err.stack);
    return;
  }
  console.log('connected');
});

But I get :

error connecting: Error: connect ETIMEDOUT

Everytime, not matter what I do, like changing the timeout, remove the port or anything else. Any idea ? I'm running this on ArchLinux x86_64

What kind of hosting service is the database on? I'm asking because usually they don't allow remote connections to the database. Is the node server on the same machine or on a different one? — Aioros
– Aioros, Commented Oct 26, 2016 at 9:35
It's hosted on OVH and there's no problem to access it via PHP — Arty
– Arty, Commented Oct 26, 2016 at 9:47

Arty · Accepted Answer · 2016-10-26 12:10:58Z

2

I finally found the answer : OVH doesn't allow customers to use their MySQL Database out of their services which means that if you want to run code using MySQL OVH database, you have to run the code into a OVH server.

answered Oct 26, 2016 at 12:10

Arty

3555 silver badges23 bronze badges

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

Comments

Alex Grace · Accepted Answer · 2016-10-26 09:46:13Z

0

This looks like a timeout error. Please try taking the port number out of the quote marks. Hopefully this will fix the issue!

 var connection = mysql.createConnection({
     host     : 'my_ip',
     port     : 3306,
     user     : 'my_user',
     password : 'my_pass',
     connectTimeout : 10000
});

answered Oct 26, 2016 at 9:46

Alex Grace

266 bronze badges

4 Comments

Arty Over a year ago

Unfortunatly, it didn't change anything

Alex Grace Over a year ago

Okay and can you connect to the remotely database using the same credentials in MySQLWorkbench for example?

Arty Over a year ago

It doesn't work, something might be wrong in the IP then ... Thanks for the help !

Alex Grace Over a year ago

Yes, could be many things, is the database allowing remote connections or is it locked down? And are the credentials correct?

Collectives™ on Stack Overflow

MySQL Connection on Node.JS

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related