node.js - 当我启动 .js 服务器文件时出现错误 : connect ECONNREFUSED into node. js

Question

Error: connect ECONNREFUSED Ip address:3306
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1106:14)
    --------------------
    at Protocol._enqueue (/App Directory Pat /node_modules/mysql/lib/protocol/Protocol.js:144:48)
    at Protocol.handshake (/**App Directory Path**/node_modules/mysql/lib/protocol/Protocol.js:51:23)
    at Connection.connect (/**App Directory Path**/node_modules/mysql/lib/Connection.js:119:18)
    at Object.<anonymous> (/var/www/html/app/videostatus/app.js:17:12)
    at Module._compile (internal/modules/cjs/loader.js:776:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:787:10)
    at Module.load (internal/modules/cjs/loader.js:653:32)
    at tryModuleLoad (internal/modules/cjs/loader.js:593:12)
    at Function.Module._load (internal/modules/cjs/loader.js:585:3)
    at Function.Module.runMain (internal/modules/cjs/loader.js:829:12)

这是我的 Node.js 代码

var http = require('http');

http.createServer(function (req, res) {
  res.writeHead(200, {'Content-Type': 'text/plain'});
  res.end('Hello World!');
}).listen(3006);

var mysql      = require('mysql');
var connection = mysql.createConnection({
 host: '',
  user: '',
  password: '',
  database: ''
});

connection.connect((err) => {
    if (err) {
        return console.error(err);
    }
});
connection.query('SELECT * FROM category_master where category_isactive = 1 ORDER BY `order` ASC', function (error, results, fields) {
  if (error) throw error;
  console.log('The solution is: ', results[0].solution);
});

connection.end();

请帮助我，我已经花了两天但没有找到任何东西。谢谢。

Answer 1

您的 MySQL 服务器似乎没有运行。

如果您确定它正在运行，那么您在 mysql.createConnection() 中使用了错误的主机。您应该使用 127.0.0.1，但您也可以尝试 localhost 或 ::1。 (IPv6 相当于 127.0.0.1)。