pip install pymysql

import pymysql.cursors

db = pymysql.connect(host='host.mysql.com', 
                     user='usuario',
                     passwd='senha',
                     db='banco de dados')

cur = db.cursor()

# to apply SQL
cur.execute('SELECT * FROM tabela;')

for row in cur.fetchall():
    print(row)

db.close()