Express 错误：连接丢失：服务器关闭了连接。 大佬们如何解决？

Question

Express 错误：连接丢失：服务器关闭了连接。 大佬们如何解决

var express = require('express');
var app = express();

const cors = require('cors');

app.use(cors());

app.use(express.static('./public'))

const bodyParser = require('body-parser')

app.use(bodyParser.urlencoded({ extended: true }));

const router = require('./routes/api.js');

app.use('/api', router);

var server = app.listen(8081, function () {

var host = server.address().address
var port = server.address().port

console.log("应用实例，访问地址为 http://localhost:8081", host, port)

})

// 报错信息
node:events:496

  throw er; // Unhandled 'error' event
  

Error: Connection lost: The server closed the connection.

at Protocol.end (C:\Users\Administrator\Desktop\books_serve\node_modules\mysql\lib\protocol\Protocol.js:112:13)
at Socket.<anonymous> (C:\Users\Administrator\Desktop\books_serve\node_modules\mysql\lib\Connection.js:94:28)
at Socket.<anonymous> (C:\Users\Administrator\Desktop\books_serve\node_modules\mysql\lib\Connection.js:526:10)
at Socket.emit (node:events:530:35)
at endReadableNT (node:internal/streams/readable:1696:12)
at process.processTicksAndRejections (node:internal/process/task_queues:82:21)

Emitted 'error' event on Connection instance at:

at Connection._handleProtocolError (C:\Users\Administrator\Desktop\books_serve\node_modules\mysql\lib\Connection.js:423:8)
at Protocol.emit (node:events:518:28)
at Protocol._delegateError (C:\Users\Administrator\Desktop\books_serve\node_modules\mysql\lib\protocol\Protocol.js:398:10)
at Protocol.end (C:\Users\Administrator\Desktop\books_serve\node_modules\mysql\lib\protocol\Protocol.js:116:8)
at Socket.<anonymous> (C:\Users\Administrator\Desktop\books_serve\node_modules\mysql\lib\Connection.js:94:28)
[... lines matching original stack trace ...]
at process.processTicksAndRejections (node:internal/process/task_queues:82:21) {

fatal: true,
code: 'PROTOCOL_CONNECTION_LOST'
}

Node.js v20.11.0
[nodemon] app crashed - waiting for file changes before starting...
[nodemon] restarting due to changes...
[nodemon] starting node .\app.js

各位大佬如何解决

Answer 1

连接数据库报错了，排查一下连接mysql的配置