node创建mysql数据库

npm install mysql

const mysql = require('mysql');

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

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

connection.query('CREATE DATABASE IF NOT EXISTS mydatabase', (error, results) => {
  if (error) {
    console.error('Error creating database: ', error);
    return;
  }
  console.log('Database created successfully!');
});

connection.end((error) => {
  if (error) {
    console.error('Error disconnecting from MySQL database: ', error);
    return;
  }
  console.log('Disconnected from MySQL database!');
});