Environment variables not being loaded

24 views Asked by At

I'm trying to create a mysql2 connection on nodejs but It's not loading my variables

this is how it's set up the function


const pool = mysql.createPool({
  host: process.env.DB_HOST,
  user: process.env.DB_USER,
  password: process.env.DB_PASSWORD,
  database: process.env.DB_NAME,
  connectionLimit: 10,
});

export async function dbConnection() {
  if (!process.env.DB_HOST || !process.env.DB_USER || !process.env.DB_PASSWORD || !process.env.DB_NAME) {
    throw new Error('Missing environment variables for database connection');
  }
  console.log(process.env.DB_HOST, process.env.DB_HOST, process.env.DB_USER, process.env.DB_PASSWORD, process.env.DB_NAME);
  const connection = await pool.getConnection();
  return connection;
}

I already checked packages and reinstalling node package, dotenv is configured as well.

0

There are 0 answers