db.js

// db.js - creates and exports a MySQL connection pool
import mysql from 'mysql2/promise';
import dotenv from 'dotenv';

dotenv.config();

const db = mysql.createPool({
   host: process.env.DB_HOST || 'localhost',
   port: Number(process.env.DB_PORT || 3306),
   user: process.env.DB_USER || 'root',
   password: process.env.DB_PASSWORD || '',
   database: process.env.DB_NAME || 'my_database',
   waitForConnections: true,
   connectionLimit: 10,
   queueLimit: 0,
 });



(async () => {
  try {
    const connection = await db.getConnection();
    console.log('MySQL connected!');
    connection.release();
  } catch (err) {
    console.error('MySQL connection failed:', err.message);
  }
})();

export default db;