mysqlclient_connect_query_fetch_quickstart.py

1import MySQLdb
2
3# Connect to the database
4# Replace with your own host, user, password, and database name
5db = MySQLdb.connect(host="localhost",
6                     user="user",
7                     passwd="password",
8                     db="database_name")
9
10# Create a cursor object
11cur = db.cursor()
12
13# Execute a query
14cur.execute("SELECT VERSION()")
15
16# Fetch the result
17data = cur.fetchone()
18print("MySQL version:", data[0])
19
20# Close the connection
21db.close()