带有MySQL的NodeJS (Express) -如何处理连接重置？

const mysql = require('mysql2');

const pool = mysql.createPool({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase',
  waitForConnections: true,
  connectionLimit: 10,
  queueLimit: 0
});

// 处理连接重置错误
pool.on('error', (err) => {
  if (err.code === 'PROTOCOL_CONNECTION_RESET') {
    console.log('Connection reset. Reconnecting...');
    // 重新连接到MySQL服务器
    pool.getConnection((error, connection) => {
      if (error) {
        console.error('Error reconnecting:', error);
      } else {
        console.log('Reconnected successfully!');
        connection.release();
      }
    });
  } else {
    console.error('Database error:', err);
  }
});

// 使用连接池执行查询
pool.query('SELECT * FROM mytable', (error, results) => {
  if (error) {
    console.error('Query error:', error);
  } else {
    console.log('Query results:', results);
  }
});