mysql - 如何解决分段故障（核心转储）？

Question

我正在尝试使用 MySQL 游标与远程数据库进行交互：

from flask import Flask
from flask_mysqldb import MySQL

app = Flask(__name__)
app.config['MYSQL_USER'] = 'sql7368254'  # it's a testing database. Nothing to exploit, really.
app.config['MYSQL_PASSWORD'] = 'YnCZ8j4jbi'
app.config['MYSQL_HOST'] = 'sql7.freemysqlhosting.net'
app.config['MYSQL_DB'] = 'sql7368254'
app.config['MYSQL_CURSORCLASS'] = 'DictCursor'
db = MySQL(app)

@app.route('/')
def index():
    cur = db.connection.cursor()
    cur.execute('''CREATE TABLE users (id INTEGER, email VARCHAR(30), password VARCHAR(255))''')
    return 'Done'

if __name__ == '__main__':
    app.run(debug=True)

当我把它关闭时，我得到：

* Serving Flask app "server.py"
 * Environment: production
   WARNING: This is a development server. Do not use it in a production deployment.
   Use a production WSGI server instead.
 * Debug mode: off
Segmentation fault (core dumped)

“分段错误”并没有告诉我出了什么问题。可能是什么问题？

标签： mysqlflask

Answer 1

导入是一个问题：

from flask_mysqldb import MySQL

如本主题所述。Flask-MySQLdb 不能很好地与 Python 3 配合使用。建议改用 Python MySQL 连接器。