Flask-Mysqldb NameError: name '_mysql' is not defined

Question

I've been trying to solve this problem for a while now. I tried everything I can find and still nothing. Kindly help.

from flask import Flask, request, jsonify
from flask_mysqldb import MySQL

app = Flask(__name__)

app.config['MYSQL_USER'] = 'root'
app.config['MYSQL_PASSOWRD'] = 'password'
app.config['MYSQL_HOST'] = 'localhost'
app.config['MYSQL_DB'] = 'try_flask'

app.config['MYSQL_CURSORCLASS'] = 'DictCursor'

mysql = MySQL(app)

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

@app.route('/employee', methods=['GET','POST'])
def employee():
    if request.method == 'GET':
        cur = mysql.connection.cursor()
        cur.execute('''SELECT * FROM employee''')
        results = cur.fetchall()
    return jsonify(results)

This is my code, and it always return: File "app1.py", line 3, in from flask_mysqldb import MySQL File "/usr/local/lib/python3.8/site-packages/flask_mysqldb/init.py", line 1, in import MySQLdb File "/usr/local/lib/python3.8/site-packages/MySQLdb/init.py", line 24, in version_info, _mysql.version_info, _mysql.file

NameError: name '_mysql' is not defined

I'm using macOS catalina, python 3.8.5 from Visual Studio Code. I have MySQL prefpane, MySQL client, MySQL connector all installed.

Mansur Ul Hasan · Accepted Answer · 2020-12-05 13:22:15Z

0

It looks like you are initializing app bit earlier your code should looks like this

from flask import Flask, request, jsonify
from flask_mysqldb import MySQL

app = Flask(__name__)

app.config['MYSQL_USER'] = 'root'
app.config['MYSQL_PASSOWRD'] = 'password'
app.config['MYSQL_HOST'] = 'localhost'
app.config['MYSQL_DB'] = 'try_flask'

app.config['MYSQL_CURSORCLASS'] = 'DictCursor'

mysql = MySQL(app)

@app.route('/employee', methods=['GET','POST'])
def employee():
    if request.method == 'GET':
        cur = mysql.connection.cursor()
        cur.execute('''SELECT * FROM employee''')
        results = cur.fetchall()
    return jsonify(results)
## i saw everywhere app started at then end of app.py
if __name__ == '__main__':
    app.run(debug=True)

answered Dec 5, 2020 at 13:22

Mansur Ul Hasan

3,67632 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

theguy Over a year ago

Thank you for your reply! Somehow after I update my python the code works! I think there were some error between my python and sql.

Collectives™ on Stack Overflow

Flask-Mysqldb NameError: name '_mysql' is not defined

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related