AttributeError when initializing Flask app - 'MySQL' object has no attribute 'connection'

Question

I'm trying to run a flask app together with a MySQL server. But I can't seem to get pass the connect-to-db stage. My app.py has the following code:

from flask import Flask, render_template
from flaskext.mysql import MySQL

app = Flask(__name__)
mysql = MySQL()

app.config['MYSQL_DATABASE_HOST '] = 'localhost'
app.config['MYSQL_DATABASE_USER'] = 'root'
app.config['MYSQL_DATABASE_PASSWORD'] = 'mypassword'
app.config['MYSQL_DATABASE_DB'] = 'users'
app.config['MYSQL_CURSORCLASS'] = 'DictCursor'
mysql.init_app(app)
cur = mysql.connection.cursor()

@app.route('/')
def index():
    return render_template('layout.html')

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

When I run this script in Git Bash, I get:

$ python app.py
Traceback (most recent call last):
  File "app.py", line 13, in <module>
    cur = mysql.connection.cursor()
AttributeError: 'MySQL' object has no attribute 'connection'

I do not see any issue with the app.py script above. The MySQL module is imported, initialized and it still does not run. Can someone please offer some suggestions of what could possibly be the problem?

Try this: from flask_mysqldb import MySQL instead of from flaskext.mysql import MySQL... Or use your previous import and use the cursos as: cur = mysql.get_db().cursor(). — Dalton Cézane
– Dalton Cézane, Commented Feb 18, 2018 at 18:46

user9371612 · Accepted Answer · 2018-02-18 18:44:48Z

1

I think you should import this and then run your code :

import mysql
import mysql.connector

answered Feb 18, 2018 at 18:44

user9371612

1001 silver badge12 bronze badges

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

Comments

Dalton Cézane · Accepted Answer · 2018-02-18 18:52:37Z

0

You can change the way you are getting the cursor to:

mysql.init_app(app)
cur = mysql.get_db().cursor()

Or use your previous code and change the import line to:

from flask_mysqldb import MySQL

I hope it helps.

answered Feb 18, 2018 at 18:52

Dalton Cézane

3,8213 gold badges42 silver badges64 bronze badges

Collectives™ on Stack Overflow

AttributeError when initializing Flask app - 'MySQL' object has no attribute 'connection'

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related