pymysql

#!/usr/bin/env python
# -*- coding: utf-8 -*-
# Script que se conecta a una base MySQL
# instalar previamente pymysql: pip install pymysql

import pymysql

conn = pymysql.connect(
        host = "localhost",
        user = "root",
        port = 3306,
        passwd = "",
        db = "comercioit"
        )

cursor = conn.cursor()


cursor.execute("SELECT * FROM productos")
datos = cursor.fetchall()
print(datos)

# cerrar la base
conn.close()