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

var mysqlConnection = mysql.createConnection({
    host: process.env.DB_HOST1,
    user: process.env.DB_USER1,
    password: process.env.DB_PASSWORD1,
    database: process.env.DB_NAME1,
    multipleStatements: true
  });
  
mysqlConnection.connect((err) => {
    !err ? console.log("Connected to database!") : console.log("Failed connecting to db: " + JSON.stringify(err));
});

module.exports = mysqlConnection;