nodejs怎么连接mysql

npm install mysql

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'my_password',
  database: 'my_database'
});

connection.connect((err) => {
  if (err) {
    console.error('error connecting: ' + err.stack);
    return;
  }

  console.log('connected as id ' + connection.threadId);
});

connection.query('SELECT * FROM my_table', (err, rows) => {
  if (err) {
    console.error('error querying: ' + err.stack);
    return;
  }

  console.log('rows: ', rows);
});

connection.end((err) => {
  // ...
});