如何将node.js连接到MySQL

Question

我正在尝试将node.js连接到MySQL，但失败了。我已经安装了MySQL和相关库。如何解决此错误？另外，如果我想让数据响应为原生的，我应该如何去做呢？

const express = require('express');
const mysql = require('mysql');

const connection = mysql.createPool({
  host     : '*****',//aws db endpoint/MySQL hostname
  user     : 'administrator', // username of MySQL connection
  password : '*****', //pw of MySQL db
  database : 'database_3' // name of database to be used
});

const app = express();
app.get('/User', function (req, res) {
    connection.getConnection(function (err, connection) {
    connection.query('SELECT * FROM User', function (error, results, fields) {
      if (error) throw error;
      res.send(results)
    });
  });
});

// Starting our server.
app.listen(3306, () => {
    console.log('Go to http://localhost:3306/User');
   });
   

收到的错误消息：

events.js:174
      throw er; // Unhandled 'error' event
      ^

Error: listen EADDRINUSE: address already in use :::3306
    at Server.setupListenHandle [as _listen2] (net.js:1279:14)
    at listenInCluster (net.js:1327:12)
    at Server.listen (net.js:1414:7)
    at Function.listen (C:\Users\Irvin\my-new-project\node_modules\express\lib\application.js:618:24)
    at Object.<anonymous> (C:\Users\Irvin\my-new-project\route.js:39:5)
    at Module._compile (internal/modules/cjs/loader.js:778:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:789: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)
Emitted 'error' event at:
    at emitErrorNT (net.js:1306:8)
    at process._tickCallback (internal/process/next_tick.js:63:19)
    at Function.Module.runMain (internal/modules/cjs/loader.js:834:11)
    at startup (internal/bootstrap/node.js:283:19)
    at bootstrapNodeJSCore (internal/bootstrap/node.js:622:3)

Answer 1

错误：侦听EADDrinUse：address已在使用：：：3306

这意味着端口3306已在使用中，请尝试将其更改为其他端口或停止在该端口上运行的进程。

// Lets change 3306 to 3307
app.listen(3307, () => {
    console.log('Go to http://localhost:3307/User');
});

如果您想要停止这个端口上的进程，下面是如何在linux上执行