nodejs and mysql connection failing?

Question

var mysql = require('mysql');

var client = mysql.createClient({
  user: 'myusername',
  password: 'mypassword',
});

client.query('USE mydb');

A simple setup like this using node's mysql is returning an ECONNREFUSED error, although the credentials are correct and permissions are updated. I have even used a different node module to successfully connect/query the database using the same credentials, but the syntax of this module is in my opinion far superior.

Anyone have an idea whats causing this to go wrong?

Error:

node.js:201 throw e; // process.nextTick error, or 'error' event on first tick
^
Error: connect ECONNREFUSED

http://stackoverflow.com/questions/8825342/connect-econnrefused-node-js-sql — Amol M Kulkarni, Sep 13 '13 at 10:04

score 2 · Accepted Answer · answered Mar 10 '12 at 22:13

2

In mysql.conf, comment skip-networking.

answered Mar 10 '12 at 22:13

Ghostman

6,042
9
34
53

Devrath · Answer 2 · 2013-06-27T08:35:16.447

For creating the database you need to use the command CreateConnection and not createClient, make the necessary changes and that should work !

var mysql = require('mysql');

var client = mysql.createConnection({
  host: 'localhost',
  user: 'myusername',
  password: 'mypassword',
});

client.query('USE mydb');

Note that you have not mentioned which database you are accessing !

Source for this solution:: Check NODEJS Github here

nodejs and mysql connection failing?

2 Answers2