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

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

Collectives™ on Stack Overflow

nodejs and mysql connection failing?

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related