Connecting Python with MySQL allows you to interact with a MySQL database directly from your Python applications.<\/p>\n\n\n\n
You can:<\/p>\n\n\n\n
Insert data
Fetch records
Update data
Delete records
Build backend applications<\/p>\n\n\n\n
This is commonly used in:<\/p>\n\n\n\n
Web development
Data engineering
Automation scripts
Backend APIs<\/p>\n\n\n\n
Install the official MySQL connector:<\/p>\n\n\n\n
pip install mysql-connector-python<\/pre>\n\n\n\nStep 2: Import and Connect to Database<\/h1>\n\n\n\n
Example:<\/p>\n\n\n\n
import mysql.connectorconnection = mysql.connector.connect(
host=\"localhost\",
user=\"root\",
password=\"your_password\",
database=\"your_database\"
)print(\"Connected successfully!\")<\/pre>\n\n\n\nIf connection is successful, Python is now connected to MySQL.<\/p>\n\n\n\n
Step 3: Create a Cursor<\/h1>\n\n\n\n
Cursor allows you to execute SQL queries.<\/p>\n\n\n\n
cursor = connection.cursor()<\/pre>\n\n\n\nStep 4: Execute SQL Query<\/h1>\n\n\n\n
Example: Create a table<\/p>\n\n\n\n
cursor.execute(\"\"\"
CREATE TABLE IF NOT EXISTS users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100),
email VARCHAR(100)
)
\"\"\")<\/pre>\n\n\n\nStep 5: Insert Data<\/h1>\n\n\n\n
query = \"INSERT INTO users (name, email) VALUES (%s, %s)\"
values = (\"Ali\", \"ali@email.com\")cursor.execute(query, values)
connection.commit()print(\"Data inserted successfully!\")<\/pre>\n\n\n\nImportant:<\/p>\n\n\n\n
Always use parameterized queries (%s) to prevent SQL injection.<\/p>\n\n\n\n
Step 6: Fetch Data<\/h1>\n\n\n\n
cursor.execute(\"SELECT * FROM users\")
results = cursor.fetchall()for row in results:
print(row)<\/pre>\n\n\n\nYou can also use:<\/p>\n\n\n\n
fetchone() \u2192 Single record
fetchmany(n) \u2192 Multiple records<\/p>\n\n\n\nStep 7: Update Data<\/h1>\n\n\n\n
query = \"UPDATE users SET name = %s WHERE id = %s\"
values = (\"Ahmed\", 1)cursor.execute(query, values)
connection.commit()<\/pre>\n\n\n\nStep 8: Delete Data<\/h1>\n\n\n\n
query = \"DELETE FROM users WHERE id = %s\"
values = (1,)cursor.execute(query, values)
connection.commit()<\/pre>\n\n\n\nStep 9: Close Connection<\/h1>\n\n\n\n
Always close connections to free resources.<\/p>\n\n\n\n
cursor.close()
connection.close()<\/pre>\n\n\n\nHandling Errors<\/h1>\n\n\n\n
Use try-except block:<\/p>\n\n\n\n
import mysql.connector
from mysql.connector import Errortry:
connection = mysql.connector.connect(
host=\"localhost\",
user=\"root\",
password=\"your_password\",
database=\"your_database\"
)
print(\"Connected successfully!\")except Error as e:
print(\"Error:\", e)<\/pre>\n\n\n\nBest Practices<\/h1>\n\n\n\n
Use parameterized queries
Close connections properly
Handle exceptions
Use connection pooling for large applications
Never hardcode sensitive credentials<\/p>\n\n\n\nReal-World Use Case<\/h1>\n\n\n\n
Web Application:<\/p>\n\n\n\n
User submits form
Python backend stores data in MySQL
Data retrieved and displayed on dashboard<\/p>\n\n\n\nThis integration is fundamental in backend development.<\/p>\n\n\n\n
Key Takeaway<\/h1>\n\n\n\n
Connecting Python with MySQL enables powerful database operations directly from Python applications.<\/p>\n\n\n\n
By using mysql-connector, parameterized queries, and proper error handling, you can build secure and scalable database-driven systems.<\/p>\n\n\n