text: import dotenv from "dotenv";
  dotenv.config({
    path: "/Users/loaner-mbp-0002/Library/CloudStorage/OneDrive-KøbenhavnsErhvervsakademi/Computer Science  - KEA/4 Semester/NodeJS/NodeJS_HandIn/9._Cinema/.env",
  });
  import mysql from "mysql2";
  
  const connection = mysql.createConnection({
    host: process.env.DB_HOST,
    user: "root",
    password: process.env.DB_PASSWORD,
    database: process.env.DB_DATABASE,
  });
  
  connection.connect();
  
  console.log(connection);
  
  export default connection;
  