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://chengdu.cdxwcx.cn/article/ijeegh.html