Python
import MySQLdb
conn = MySQLdb.connect(host='localhost', user='root', passwd='password', db='mydatabase')
cursor = conn.cursor()
cursor.execute("SELECT * FROM mytable")
results = cursor.fetchall()
for row in results:
print(row)
cursor.close()
conn.close()
pip install mysqlclient
