import mysql.connector
from mysql.connector import Error
from .config import Config

def get_db_connection():
    """Establish a connection to the MySQL database."""
    try:
        conn = mysql.connector.connect(
            host=Config.DB_HOST,
            port=Config.DB_PORT,
            user=Config.DB_USER,
            password=Config.DB_PASSWORD,
            database=Config.DB_NAME
        )
        if conn.is_connected():
            return conn
        else:
            conn.close()
            return None
    except Error as e:
        print(f"DEBUG: FATAL: Error connecting to MySQL database: {e}")
        return None