node-mysql error: connect ECONNREFUSED

问题:

I'm trying to setup a remote connection between my database server and a client node app using node-mysql.

When I try to connect to the remote db, 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:646:11)
    at Object.afterConnect [as oncomplete] (net.js:637:18)

Connecting to a local db works ok (with the socketPort parameter).

I can connect to this remote db with PHP from my computer localhost as well as another server I own so I don't think there's something wrong with mysql conf.

For info, nodejs is running with nginx and I've setup a proxy to make node work on port 80, maybe this is the issue?

How can I check that?

Thanks.

EDIT

Here's my code, just in case:

var express = require('express');
var mysql = require('mysql');
var app = express();
var connection = mysql.createConnection({
    debug: false,
    host: '12.34.56.67',
    user: 'user',
    password: 'pass'
});

回答1:

Try using mysql socket:

var connection = mysql.createConnection({
    user: 'user',
    password: 'pass',
    socketPath: 'mysql-socket-path', /*example: /Applications/MAMP/tmp/mysql/mysql.sock*/
    database: 'dbname'
});

回答2:

Should one still look for an answer:

Check your MySql server's configuration.

In my case running netstat -ln | grep mysql(as per Troubleshooting Problems Connecting to MySQL) revealed that my server is listening on the socket /tmp/mysql.sock so in createConnection's options I used socketPath: '/tmp/mysql.sock' instead of host: and port:

回答3:

This error has to do with the MySQL client not being able to connect to the host:port given. As defined in errno.h, ECONNREFUSED is an error that is thrown when a connection is refused - this is possibly caused by:

• a firewall such as iptables blocking the port
• no such process running on the port
• the process is running on a different host
• the host or port were incorrect

In my case, my MySQL server was not correctly bound to 0.0.0.0 for external connections, instead being bound to 127.0.0.1, as it is by default; however you can change this.

The error does not originate from the node-mysql package, as doubly shown by the stacktrace, which only shows errors from net.js.

回答4:

Ok so I checked with node-mysql dev and it seems that it's not a node-mysql bug, but it was hard to investigate more.

Anyway, I found this lib which works, so I'll go with it.

https://github.com/mariano/node-db-mysql

回答5:

i had the same problem. solved it, by set the right port in the createConnection function options.

get your port by using following command: netstat -tlnp

search for program name mysqld or just named.

回答6:

I added port:3306, that solved the issue .

var connection = mysql.createConnection
    ({
        user: 'root',
        password: 'root',
        server: 'localhost',
    port:3306,
        database: 'abcd',
        insecureAuth: true,
        dialect: 'mysql',   
        multipleStatements: true,
        pool: {
            max: 5,
            min: 0,
            acquire: 30000,
            idle: 10000
        }
    });

    connection.connect();

回答7:

Use the command: yarn run start, and DO NOT use: cd /folderX && yarn run start