Node js MySQL connection Issue

Question

I have been trying to establish connection between Node.js application and mysql and have tried everything and couldn't succeed.

I'm able to connect through PHP application. My port is default where 3306

Can anyone help me to resolve this?

var mysql = require('mysql');
var connection = mysql.createConnection({
    host     : 'localhost',
    user     : 'root',
    password : 'root'
  });

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

    console.log('connected as id ' + connection.threadId);
  });   
[This is the error message I got,I can able to connect through my php application][1]

This is the error message I got,I can able to connect through my php application

Did ur application server has the permission to access the DB?? — Subburaj
– Subburaj, Commented Apr 9, 2018 at 5:10

harish_sng · Accepted Answer · 2018-04-09 11:51:59Z

2

Uncomment "bind-address" and assign bind-address="0.0.0.0". For More Information please refer this, Solving a "communications link failure" with JDBC and MySQL

answered Apr 9, 2018 at 11:51

harish_sng

4352 silver badges13 bronze badges

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

Comments

AbhinavD · Accepted Answer · 2018-04-09 05:16:44Z

1

A better approach to connect to DB is to use pools to connect to DB.

Copying from here

var mysql = require('mysql');
var pool  = mysql.createPool({
  host     : 'example.org',
  user     : 'bob',
  password : 'secret'
});

pool.getConnection(function(err, connection) {
  // connected! (unless `err` is set)
  connection.release();
});

This also allow you to make parallel calls to your database.

answered Apr 9, 2018 at 5:16

AbhinavD

7,3825 gold badges32 silver badges41 bronze badges

5 Comments

Senthil Kumar Over a year ago

I used above code but still not got succeeded . var pool = mysql.createPool({ host : 'localhost', user : 'root', password : 'root', database: 'promotool' }); pool.getConnection(function(err, connection) { // connected! (unless err is set) console.log(err); connection.release(); });Got Error { Error: Handshake inactivity timeout F:\projects\upload_promotool\node_modules\express\lib\router\index.js:281:22 code: 'PROTOCOL_SEQUENCE_TIMEOUT', fatal: true, timeout: 10000 }

AbhinavD Over a year ago

This is weird. Can you try and specify the timeout manually pool = require('mysql').createPool({ connectionLimit : 1000, connectTimeout : 60 * 60 * 1000, aquireTimeout : 60 * 60 * 1000, timeout : 60 * 60 * 1000,

Senthil Kumar Over a year ago

Yeah Its quite wierd stuff,Still got this error code: 'PROTOCOL_SEQUENCE_TIMEOUT', fatal: true, timeout: 10000 } F:\projects\upload_promotool\app.js:23 connection.release(); ^ TypeError: Cannot read property 'release' of undefined

AbhinavD Over a year ago

Is you got 'release' of undefined, it means your connection object is undefined. make sure you use the same variables as you have used in the callback function

Senthil Kumar Over a year ago

pool = require('mysql').createPool({ connectionLimit : 1000, connectTimeout : 60 * 60 * 1000, aquireTimeout : 60 * 60 * 1000, timeout : 60 * 60 * 1000, host : 'localhost', user : 'root', password : 'root', database: 'promotool' }); pool.getConnection(function(err, connection) { // connected! (unless err is set) console.log(err); connection.release(); });

Collectives™ on Stack Overflow

Node js MySQL connection Issue

2 Answers 2

Comments

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related