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://myzitong.com/article/ijeegh.html