MySQL Connector/Python

import os
import mysql.connector
from mysql.connector import Error

host = os.environ.get('MYSQL_HOST', 'localhost')
user = os.environ.get('MYSQL_USER', 'root')
password = os.environ.get('MYSQL_PASSWORD', 'your_password')
database = os.environ.get('MYSQL_DATABASE', 'test_db')

conn = None
try:
    conn = mysql.connector.connect(
        host=host,
        user=user,
        password=password,
        database=database
    )

    if conn.is_connected():
        print(f"Connected to MySQL database: {database}")
        cursor = conn.cursor()

        # Create a table (DDL - auto-commits)
        cursor.execute("CREATE TABLE IF NOT EXISTS users (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), email VARCHAR(255))")
        print("Table 'users' ensured to exist.")

        # Insert data (DML - requires commit)
        sql_insert = "INSERT INTO users (name, email) VALUES (%s, %s)"
        data_to_insert = ("Alice", "alice@example.com")
        cursor.execute(sql_insert, data_to_insert)
        conn.commit() # Important: Commit changes for DML operations
        print(f"Inserted: {cursor.rowcount} row(s)")

        # Select data
        cursor.execute("SELECT id, name, email FROM users")
        records = cursor.fetchall()
        print("\nData from 'users' table:")
        for row in records:
            print(row)

    else:
        print("Failed to connect to MySQL database.")

except Error as e:
    print(f"Error connecting to MySQL: {e}")
finally:
    if conn and conn.is_connected():
        conn.close()
        print("MySQL connection closed.")