nodejs to mysql connection error

Question

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

@Subburaj I had tried that..but I want to connect without setTimeout i.e.I dont want to wake it up by setting timeout — Gayathri
– Gayathri, Commented Apr 28, 2016 at 6:30
@Abhik Chakraborty ..It dosn't works..Im receiving the same error. — Gayathri
– Gayathri, Commented Apr 28, 2016 at 6:31

Manish · Accepted Answer · 2018-06-23 13:14:07Z

1

I connected mysql to node by like this.

Install mysql

npm install mysql

var mysql = require('mysql');

let connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    port: '8888',  /* port on which phpmyadmin run */
    password: 'root',
    database: 'dbname',
    socketPath: '/Applications/MAMP/tmp/mysql/mysql.sock' //for mac and linux
});

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

    console.log('Connected to the MySQL server.');
  });

answered Jun 23, 2018 at 13:14

Manish

13.6k1 gold badge14 silver badges9 bronze badges

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

Comments

Bik · Accepted Answer · 2016-04-28 06:23:54Z

0

You can use node-mysql, It very easy to use. I have used once, Here is the example :-

var mysql      = require('mysql');
var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'me',
  password : 'secret',
  database : 'my_db'
});

connection.connect();

connection.query('SELECT 1 + 1 AS solution', function(err, rows, fields) {
  if (err) throw err;
  console.log('The solution is: ', rows[0].solution);
});

connection.end();

answered Apr 28, 2016 at 6:23

Bik

55310 silver badges31 bronze badges

2 Comments

Gayathri Over a year ago

I had installed node-mysql module.

Gayathri Over a year ago

Im using that only.Thanks for your reply.

Subburaj · Accepted Answer · 2016-04-28 08:59:12Z

0

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.
  });
});

answered Apr 28, 2016 at 8:59

Subburaj

5,21211 gold badges48 silver badges95 bronze badges

3 Comments

Gayathri Over a year ago

But I dont know why Im getting this Error: Handshake inactivity timeout

Subburaj Over a year ago

This is related to node.js. refer this post stackoverflow.com/questions/33101869/…

Gayathri Over a year ago

I'm getting the same error after upgrading to node version 4.2.1 :(

Collectives™ on Stack Overflow

nodejs to mysql connection error

3 Answers 3

Comments

2 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related