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

stackoverflow.com/questions/8825342/…

Amol M Kulkarni
– Amol M Kulkarni

2013-09-13 10:04:57 +00:00
Commented Sep 13, 2013 at 10:04 — Amol M Kulkarni
– Amol M Kulkarni, Commented Sep 13, 2013 at 10:04

Ghostman · Accepted Answer · 2012-03-10 22:13:53Z

2

In mysql.conf, comment skip-networking.

answered Mar 10, 2012 at 22:13

Ghostman

6,1129 gold badges36 silver badges53 bronze badges

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

Comments

Devrath · Accepted Answer · 2013-06-27 08:35:16Z

1

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

edited Jun 27, 2013 at 8:35

answered Jun 27, 2013 at 7:35

Devrath

42.9k55 gold badges209 silver badges314 bronze badges

Collectives™ on Stack Overflow

nodejs and mysql connection failing?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related