const mysql = require('mysql2/promise'); const dotenv = require('dotenv'); dotenv.config(); // Database configuration const pool = mysql.createPool({ host: process.env.DB_HOST , user: process.env.DB_USER , password: process.env.DB_PASSWORD , database: process.env.DB_NAME , waitForConnections: true, connectionLimit: 10, queueLimit: 0 }); // Test database connection async function testConnection() { try { const connection = await pool.getConnection(); console.log('Database connection established successfully'); connection.release(); } catch (error) { console.error('Error connecting to database:', error); } } testConnection(); module.exports = pool;