nodejs to mysql connection error

Question

I'm getting error :
error:Error: Handshake inactivity timeout

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

Answer 1

Use Connection Pool:

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

pool.getConnection(function(err, connection) {
  // Use the connection
  connection.query( 'SELECT something FROM sometable', function(err, rows) {
    // And done with the connection.
    connection.release();

    // Don't use the connection here, it has been returned to the pool.
  });
});

nodejs to mysql connection error

Sign up