import pymysql
connection = pymysql.connect(host='localhost',
                                user='usuario',
                                password='contraseña',
                                db='base_de_datos',
                                charset='utf8mb4',
                                cursorclass=pymysql.cursors.DictCursor)
cursor = connection.cursor()
sql = "SELECT * FROM tabla"
cursor.execute(sql)
result = cursor.fetchone()

connection.close()