pymysql连接

import pymysql

db = pymysql.connect(
    host="192.168.1.34",
    port=3306,
    user="root",
    password="123456",
    db="crawl_data",
    charset="utf8",
    cursorclass=pymysql.cursors.DictCursor,
    use_unicode=True
 )