Python mysql游标关闭连接

Question

我有一个获取我的 mysql 版本的 python 脚本，但我一直收到相同的错误“_mysql_exceptions.InterfaceError: (0, '')”

我去python2.7的控制台也试了一下，

import MySQLdb
conn = MySQLdb.connect (host="localhost",user="user", passwd="pass", db="example")
cursor = conn.cursor()
cursor.execute ("SELECT VERSION()")

Traceback (most recent call last): File "", line 1, in
File "/usr/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute self.errorhandler(self, exc, value) File "/usr/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue _mysql_exceptions.InterfaceError: (0, '')

和文件

import sys
import MySQLdb
try:
    conn = MySQLdb.connect (host="localhost",user="user", passwd="pass", db="example")
except MySQLdb.Error, e:
    print "Error %d: %s" % (e.args[0], e.args[1])
    sys.exit (1)
try:
    cursor = conn.cursor()
    cursor.execute ("SELECT VERSION()")
    row = cursor.fetchone ()
    print "server version:", row[0]
    cursor.close ()
except MySQLdb.Error, e:
    print "Error %d: %s" % (e.args[0], e.args[1])
    #sys.exit (1)
conn.close ()

[user@localhost]$ python b.py

Error 0: Traceback (most recent call last): File "b.py", line 18, in conn.close() _mysql_exceptions.ProgrammingError: closing a closed connection

谢谢

Answer 1

如果您的 try block 成功运行，那么您将关闭连接两次。我想你可以把它放在 finally block 中，这将解决你的问题。