mysql - 使用 node.js 和 MySQL 时出现连接 ECONNREFUSED 错误

Question

我正在尝试在node.js 和mysql 之间创建链接。我收到连接 ECONNREFUSED 错误。怎么解决这个问题？

代码:

var mysql = require('mysql');



var conn = mysql.createConnection({

        host : "192.164.0.114",
        user : "supriya",
        password : "root123@",
        database: "student"
}
);


var queryString = "SELECT * FROM studata";

conn.query("someurlhere",queryString, function(error, results)
{

    if(error)
    {
        throw error;
    }
    else {
        console.log(results);
    }

})

conn.end();

错误是:

Error: connect ECONNREFUSED
    at errnoException (net.js:904:11)
    at Object.afterConnect [as oncomplete] (net.js:895:19)
    --------------------
    at Protocol._enqueue (/home/supriya/node_modules/mysql/lib/protocol/Protocol.js:135:48)
    at Protocol.handshake (/home/supriya/node_modules/mysql/lib/protocol/Protocol.js:52:41)
    at Connection.connect (/home/supriya/node_modules/mysql/lib/Connection.js:109:18)
    at Connection._implyConnect (/home/supriya/node_modules/mysql/lib/Connection.js:387:10)
    at Connection.query (/home/supriya/node_modules/mysql/lib/Connection.js:174:8)
    at Object.<anonymous> (/home/supriya/node_js/example2.js:19:6)
    at Module._compile (module.js:456:26)
    at Object.Module._extensions..js (module.js:474:10)
    at Module.load (module.js:356:32)
    at Function.Module._load (module.js:312:12)

Answer 1

我也遇到了同样的问题。我调用了 node server.js，其中显示

It's Started on PORT 3000 Problem with MySQLError: connect ECONNREFUSED

通过第一行，我假设它最初启动了 mysql 服务器。然而，事实并非如此。它启动 Node 服务器，尝试连接到 mysql 服务器， Node 服务器显示 ECONNREFUSED。显然，mysql 服务器没有运行。当我以 root 身份登录 mysql 工作台并尝试执行简单查询时，我发现了这一点。在角落里它说，“..在端口 3306，它没有连接”或类似的东西。所以，结论是在某个端口上启动 server.js 启动 Node 服务器而不是 mysql 服务器。