connect ECONNREFUSED - node js , sql

Question

I have the next code in a js file:

var mysql = require('mysql');
var TEST_DATABASE = 'nodejs_mysql_test';
var TEST_TABLE = 'test';
var client = mysql.createClient({
  user: 'root',
  password: 'root',
});

client.query('CREATE DATABASE '+TEST_DATABASE, function(err) {
  if (err && err.number != mysql.ERROR_DB_CREATE_EXISTS) {
    throw err;
  }
});

But I get this error:

node.js:201
        throw e; // process.nextTick error, or 'error' event on first tick
          ^
Error: connect ECONNREFUSED
    at errnoException (net.js:632:11)
    at Object.afterConnect [as oncomplete] (net.js:623:18)

As I understand it, this is a connection problem - but how do I solve it?

( I'm working on windows 7)

Thanks!!

It would seem that for some reason the page thinks the database is up and running. It is up and running on localhost, right? — Joachim Isaksson
– Joachim Isaksson, Commented Jan 11, 2012 at 19:26
obvious question: is mysql running on the same machine, on port 3306? can you telnet localhost 3306? — seppo0010
– seppo0010, Commented Jan 11, 2012 at 19:26
when I write in CMD the line telnet localhost 3306 I get: 'telnet' is not recognized as an internal or external command, operable program or batch file. Is that what you mean? — kakush
– kakush, Commented Jan 11, 2012 at 19:39
@user1087995: what seppo0010 is getting at is are you absolutely sure there is a MySQL server running on the local machine and listening on port 3306, per the connection settings that you are using? This error indicates that you are trying to connect to a server which is not listening. — maerics
– maerics, Commented Jan 11, 2012 at 20:58
Even if it's running on the local machine, you need to be sure that MySQL is listening on localhost/127.0.0.1 and not just the external IP. — Ryan Olds
– Ryan Olds, Commented Jan 11, 2012 at 22:41

limon · Accepted Answer · 2012-03-08 14:54:34Z

19

I know two ways to solve it:

In mysql.conf, comment skip-networking.

Try to set the socket like this:

var client = mysql.createClient({
user: uuuu,
password: pppp,
host: '127.0.0.1',
port: '3306',
_socket: '/var/run/mysqld/mysqld.sock',});

edited Mar 8, 2012 at 14:54

user142162

answered Mar 7, 2012 at 17:55

limon

9471 gold badge9 silver badges19 bronze badges

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

4 Comments

nak Over a year ago

Thanks, commenting skip-networking worked for me, but the key did not, that's weird. On production I'd rather not have that option commented!

Matsemann Over a year ago

This was a rejected edit by an anonymous user: I had the same problem, so i just inserted how i solved my problem. Make sure you have the correct bind-address in the mysql config file (/etc/mysql/ my.cnf or mysql.conf). Below you have an example of what you should write in this case: bind-address = 127.0.0.1

Alex Over a year ago

I don't know why but only this worked for me: stackoverflow.com/a/20486467/2413469

gorodezkiy Over a year ago

In version 2.1.0 you should use socketPath instead of _socket

Dave Deasy · Accepted Answer · 2019-01-09 23:49:00Z

0

I got this error when MySQL Server was not running.

I changed my configuration via Initialize Database in MySQL.PrefPane, the System Preferences tool for MySQL on OS X - to Use Legacy Password Encryption - to fix ER_NOT_SUPPORTED_AUTH_MODE. This config change stopped MySQL Server and then I got ECONNREFUSED when I tried to connect to MySQL from node.js.

Fixed by restarting MySQL Server from the MySQL System Preferences tool.

answered Jan 9, 2019 at 23:49

Dave Deasy

3362 silver badges13 bronze badges

Comments

ow3n · Accepted Answer · 2022-09-25 20:59:00Z

0

Try to fix your defined port in mysql and your Node.js script. You can define the mysqld port in the *.cnf file inside the mysql directory, and you can define that port when you connect to MySQL in your Node.js script.

Something like this in the cnf file

port = 3306

edited Sep 25, 2022 at 20:59

ow3n

6,7974 gold badges61 silver badges57 bronze badges

answered Feb 20, 2019 at 14:54

b.andarzian

631 gold badge1 silver badge7 bronze badges

Collectives™ on Stack Overflow

connect ECONNREFUSED - node js , sql

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related