connect to mysql in python

main.py
pip install mysql-connector-python
35 chars
2 lines

main.py
import mysql.connector

# establish connection
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

# create a cursor
mycursor = mydb.cursor()

# execute a query
mycursor.execute("SELECT * FROM yourtable")

# fetch the results
myresult = mycursor.fetchall()

# print the results
for x in myresult:
  print(x)
387 chars
23 lines