// const mysql = require("mysql");

// const db = mysql.createPool({
//     host: "127.0.0.1",
//     user: "root",
//     password: "szh656794",
//     database: "my_db_express"
// });

const mysql = require('mysql2');
require('dotenv').config();
console.log("mysql_host", process.env.DB_HOST)

const db = mysql.createConnection({
    host: process.env.DB_HOST,
    user: process.env.DB_USER,
    password: process.env.DB_PASSWORD,
    database: process.env.DB_NAME,
    port: process.env.DB_PORT,
    charset: 'utf8mb4'
});

module.exports = db;