import mysql.connector
db_info = dict()
db_info['host'] = ‘127.0.0.1’
db_info['port'] = 3306
db_info['user'] = ‘root’
db_info['passwd'] = 'root'
db_info['database'] = 'test'
cur = mysql.connector.connect(**db_info).cursor()
cur.execute("SHOW databases;")
File "/usr/lib64/python2.7/site-packages/mysql/connector/cursor_cext.py", line 232, in execute
if not self._cnx:
ReferenceError: weakly-referenced object no longer exists
代码报错的原因是这行:cur = mysql.connector.connect(**db_info).cursor()
解决方法是:拆成两行才可以
conn = mysql.connector.connect(**db_info)
cur = conn.cursor()