pip install oursql
python
import oursql
config = {
'host': 'localhost',
'user': 'your_username',
'passwd': 'your_password',
'db': 'your_database_name'
}
conn = oursql.connect(**config)
cursor = conn.cursor()
cursor.execute("SELECT * FROM your_table_name")
rows = cursor.fetchall()
for row in rows:
print(row)
cursor.close()
conn.close()
