How do I set up a MySQL connection in Node.js?

How do I set up a MySQL connection in Node.js?

To set up a MySQL connection in Node.js, you can use the 'mysql' package. First, install it using npm: npm install mysql.

What are the steps to create a connection?

After installing the package, require it in your file and create a connection using mysql.createConnection(). You'll need to provide your database credentials.

Can you show me an example code?

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 connection pooling?

You can use mysql.createPool() instead of createConnection(). This allows you to manage multiple connections efficiently.