Select Git revision
-
Theerapong Thawiwat authoredTheerapong Thawiwat authored
db.js 1.16 KiB
// const mysql = require("mysql2");
// require("dotenv").config();
// const pool = mysql.createPool({
// host: process.env.DB_HOST || "localhost",
// user: process.env.DB_USER || "root",
// password: process.env.DB_PASS || "",
// database: process.env.DB_NAME || "mypocketapp",
// port: process.env.DB_PORT || 3306,
// });
// pool.getConnection((err) => {
// if (err) {
// console.error("❌ Database connection failed:", err);
// return;
// }
// console.log("✅ MySQL Connected...");
// });
// module.exports = pool;
const mysql = require("mysql2/promise");
require("dotenv").config();
const pool = mysql.createPool({
host: process.env.DB_HOST || "localhost",
user: process.env.DB_USER || "root",
password: process.env.DB_PASS || "",
database: process.env.DB_NAME || "mypocketapp",
port: process.env.DB_PORT || 3306,
});
// Test the database connection
(async () => {
try {
const connection = await pool.getConnection();
console.log("✅ MySQL Connected...");
connection.release(); // Release the connection back to the pool
} catch (err) {
console.error("❌ Database connection failed:", err);
}
})();
module.exports = pool;