import pymysql
from pymysql.cursors import DictCursor

connect2 = pymysql.connect(
   host='localhost',
   port=3306,
   db='dbname',
   user='root',
   passwd='123',
   charset='utf8'
)
cursor2 = connect2.cursor(DictCursor)  # cursor有参数可传入，使结果得到字典格式，而非元组