我正在尝试从mysql获取数据到node.js，这是问题所在

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 database: ', err);
    return;
  }
  console.log('Connected to MySQL database');
});

// 在这里执行你的查询操作

const query = 'SELECT * FROM your_table';

connection.query(query, (err, results) => {
  if (err) {
    console.error('Error executing MySQL query: ', err);
    return;
  }
  console.log('Query results: ', results);
});

// 关闭数据库连接
connection.end();