PyMySQLを使う

#! /usr/bin/env python
import pymysql

conn = pymysql.connect(
    host="localhost",
    user="root",
    passwd="",
    db="testing",
    charset="utf8",
    use_unicode="true",
)

with conn.cursor() as cursor:
    cursor.execute(
        "SELECT empno, ename FROM emp LIMIT %s",
        (10,),
    )
    row_list = cursor.fetchall()

print(row_list)