mysqlclient_connect_execute_select_query_fetch_results.py

1import MySQLdb
2
3# Connect to the database
4# Replace with your actual database credentials
5db = MySQLdb.connect(
6    host="localhost",
7    user="your_username",
8    passwd="your_password",
9    db="your_database_name"
10)
11
12# Create a cursor object using cursor() method
13cur = db.cursor()
14
15# Execute a SQL query using execute() method
16cur.execute("SELECT Host, User FROM mysql.user")
17
18# Fetch all the rows in a list of lists
19for row in cur.fetchall():
20    print(row[0], row[1])
21
22# Close the connection
23db.close()