Flask-MySQLdb引发_mysql_exceptions.ProgrammingError：关闭一个关闭的连接

• Z时代
• 2024-01-10
• 分类：问答

我正在尝试使用Flask-MySQLdb。每当我去一个页面，我得到错误_mysql_exceptions.ProgrammingError: closing a closed connection。为什么这不起作用？Flask-MySQLdb引发_mysql_exceptions.ProgrammingError：关闭一个关闭的连接

from flask import Flask, render_template, request, json 
from flask_mysqldb import MySQL 
application = Flask(__name__) 
mysql = MySQL(application) 
application.config['MYSQL_USER'] = 'root' 
application.config['MYSQL_PASSWORD'] = 'password' 
application.config['MYSQL_DB'] = 'db name' 
application.config['MYSQL_HOST'] = 'localhost' 
mysql.init_app(application) 
@application.route('/') 
def index(): 
    cur = mysql.connection.cursor() 
    cur.execute("SHOW TABLES") 
    rv= cur.fetchall() 
    return str(rv) 
if __name__ == "__main__": 
    application.run() 

回答：

mysql = MySQL() 
mysql.init_app(application) 

以上是 Flask-MySQLdb引发_mysql_exceptions.ProgrammingError：关闭一个关闭的连接 的全部内容， 来源链接： utcz.com/qa/258223.html