python3用的是pymysql库，功能跟mysqldb差不多

#python3.6.2
import pandas as pd
import pymysql
from sqlalchemy import create_engine
db_con = pymysql.connect(
    user = 'user',
    password = 'password',
    port = 3306,
    host = 'localhost',
    db = 'yourdatabase',
    charset='utf8',
    cursorclass=pymysql.cursors.DictCursor
    )

engine = create_engine("mysql+pymysql://user:password@host:port/databasename?charset=utf8")
df = pd.read_excel('a.xls')
df.to_sql(name = 'table_name',con = engine,if_exists = 'append',index = False,index_label = False)