Node.js Mysql:连接失败

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost', // 确保地址正确
  user: 'your_username', // 确保用户名正确
  password: 'your_password', // 确保密码正确
  database: 'your_database' // 确保数据库名称正确
});

connection.connect((err) => {
  if (err) {
    console.error('Error connecting to MySQL:', err);
    return;
  }
  console.log('Connected to MySQL database!');
});

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});

connection.connect((err) => {
  if (err) {
    console.error('Error connecting to MySQL:', err);
    return;
  }
  console.log('Connected to MySQL database!');

  // 执行查询
  connection.query('SELECT 1', (error, results, fields) => {
    if (error) throw error;
    console.log('Query result:', results);
  });

  // 关闭连接
  connection.end((err) => {
    if (err) console.error('Error closing connection:', err);
    console.log('Connection closed.');
  });
});