conn = MySQLdb.connect(host=ip, port=port, user=user, passwd=passwd, db=db, charset="utf8", connect_timeout=1)
cur = conn.cursor()
#将这3个 character_set_client, character_set_connection, and character_set_results 都设为 utf8mb4
cur.execute("set names utf8mb4")
网站栏目：pythonmysqlutf8mb4
链接分享：
http://shouzuofang.com/article/ijeegh.html