pip install oursql
pip install oursql --allow-external oursql --allow-unverified oursql
python
import oursql
conn = oursql.connect(host='localhost', port=3306, 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()
