How do I connect Node.js to MySQL?

How do I connect Node.js to MySQL?

You can use the 'mysql' package in Node.js. First, install it using npm: npm install mysql. Then, you can create a connection.

Can you show me a code example?

Sure! Here's a simple example:

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'yourUsername',
  password: 'yourPassword',
  database: 'yourDatabase'
});

connection.connect((err) => {
  if (err) throw err;
  console.log('Connected to MySQL!');
});

What if I want to use promises instead of callbacks?

You can use the 'mysql2' package, which supports promises. Install it with npm install mysql2 and use it like this:

const mysql = require('mysql2/promise');

async function connect() {
  const connection = await mysql.createConnection({
    host: 'localhost',
    user: 'yourUsername',
    password: 'yourPassword',
    database: 'yourDatabase'
  });
  console.log('Connected to MySQL!');
}
connect();