node如何使用mysql数据库

npm install mysql

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',   // 数据库主机地址
  user: 'root',        // 数据库用户名
  password: 'password',// 数据库密码
  database: 'database' // 数据库名称
});

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

connection.query('SELECT * FROM users', (error, results) => {
  if (error) {
    console.error('Failed to execute SQL query:', error);
    return;
  }
  console.log('Query results:', results);
});

connection.end((error) => {
  if (error) {
    console.error('Failed to close MySQL database connection:', error);
    return;
  }
  console.log('MySQL database connection closed!');
});