OwlCyberSecurity - MANAGER

Edit File: db.js

import { createPool } from 'mysql2/promise'; import cors from 'cors'; import dotenv from 'dotenv'; dotenv.config(); const pool = createPool({ host: process.env.DB_HOST || '127.0.0.1', user: process.env.DB_USER || 'root', password: process.env.DB_PASSWORD || '', database: process.env.DB_NAME || 'asset_management', port: process.env.DB_PORT, }); // Test connection on startup pool.getConnection() .then((connection) => { console.log(`✅ Connected to MySQL database: ${process.env.DB_NAME || 'asset_management'}`); connection.release(); }) .catch((err) => { console.error('❌ Failed to connect to MySQL:', err.message); console.error('Connection details:', { host: process.env.DB_HOST || '127.0.0.1', user: process.env.DB_USER || 'root', database: process.env.DB_NAME || 'asset_management', }); process.exit(1); }); export default pool;