连接ECONNREFUSED ExpressJS

Question

var express = require('express'),
routes = require('./routes'),
http = require('http'),
path = require('path');

  var app = express();
  console.log(__dirname);
  app.set('port', process.env.PORT || 3000);
  app.set('views', __dirname + '/views');
  app.set('view engine', 'jade');

  app.use(express.static(path.join(__dirname, 'views/')))

  app.get('/', routes.index);

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

  connection.connect();

  connection.query('SELECT * from users', function(err, rows, fields) {
    if (!err)
      console.log('The solution is: ', rows);
    else
      console.log('Error while performing Query.' + err);
  });

  connection.end();

  http.createServer(app).listen(app.get('port'), function(){

    console.log('Express is running ...');

  });

我有名为"connect ECONNREFUSED“的错误。我的代码中哪里有错误？有什么想法可以纠正这个问题吗？

我搜索了这个错误，但找不到答案:(我正在用这个enter link description here学习

Answer 1

"ECONNREFUSED“通知您已经有服务器在运行或端口已保留。因此，请先杀死该实例，然后尝试再次运行它。