摘要：
参考资源：https://blog.csdn.net/zc474235918/article/details/72731363/https://blog.csdn.net/zmx729618/article/details/51259135#importpymysql#conn=pymysql.connect（主机='127.0.0.1'，用户='root'，密码='123456'，d
参考：https://blog.csdn.net/zc474235918/article/details/72731363/
https://blog.csdn.net/zmx729618/article/details/51259135
# import pymysql
# conn=pymysql.connect(host='127.0.0.1',user='root',passwd='123456',db='mysql',charset='utf8', port=3306)
# cur=conn.cursor()
# cur.execute('use douban;')
# cur.execute("insert into douban.douban(author,actor,country) VALUES('aa','bb','bb')")
# conn.commit()
# cursor.close()
cursor未关闭时会出现lock wait timeout exceeded错误解决办法：
SELECT * FROM information_schema.INNODB_TRXG;
找到对应的trx_mysql_thread_id，然后执行kill id;
即可解决