Connecting Python with MySQL

pip install mysql-connector-python

import mysql.connector

conn = mysql.connector.connect(
    host="localhost",
    user="root",
    password="your_password",  # Replace with your actual MySQL password
    database="your_database"   # Optional at this step
)

if conn.is_connected():
    print("Connected to MySQL!")

cursor = conn.cursor()
cursor.execute("CREATE DATABASE IF NOT EXISTS demo_db")
print("Database created successfully!")

conn.database = "demo_db"

cursor.execute("""
CREATE TABLE IF NOT EXISTS users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100)
)
""")
print("Table created!")

sql = "INSERT INTO users (name, email) VALUES (%s, %s)"
values = ("John Doe", "john@example.com")
cursor.execute(sql, values)
conn.commit()

print(cursor.rowcount, "record inserted.")

cursor.execute("SELECT * FROM users")
rows = cursor.fetchall()

for row in rows:
    print(row)

sql = "UPDATE users SET email = %s WHERE name = %s"
val = ("john.doe@demo.com", "John Doe")
cursor.execute(sql, val)
conn.commit()

sql = "DELETE FROM users WHERE name = %s"
val = ("John Doe",)
cursor.execute(sql, val)
conn.commit()

cursor.close()
conn.close()