Using MySQL in Flask

by

Firstly you need to install Flask-MySQL package. Using pip for example:

pip install flask-mysql

Next you need to add some configuration and initialize MySQL:

from flask import Flask
from flaskext.mysql import MySQL

app = Flask(__name__)
mysql = MySQL()
app.config['MYSQL_DATABASE_USER'] = 'root'
app.config['MYSQL_DATABASE_PASSWORD'] = 'root'
app.config['MYSQL_DATABASE_DB'] = 'EmpData'
app.config['MYSQL_DATABASE_HOST'] = 'localhost'
mysql.init_app(app)

Now you can get connection and cursor objects and execute raw queries:

conn = mysql.connect()
cursor =conn.cursor()

cursor.execute("SELECT * from User")
data = cursor.fetchone()

More Related Contents:

  1. How can I get the named parameters from a URL using Flask?
  2. How to build a flask application around an already existing database?
  3. Split Python Flask app into multiple files
  4. RuntimeError: working outside of application context
  5. ImportError: No module named MySQLdb
  6. How to serve static files in Flask
  7. Flask view return error “View function did not return a response”
  8. PyInstaller, spec file, ImportError: No module named ‘blah’
  9. Testing code that requires a Flask app or request context
  10. How do I get the different parts of a Flask request’s url?
  11. Why use Flask’s url_for?
  12. Remove file after Flask serves it
  13. Enable Python to Connect to MySQL via SSH Tunnelling
  14. Send data from a textbox into Flask?
  15. Start a flask application in separate thread
  16. Trying to run Flask app gives “Address already in use”
  17. Flask view shows 400 error instead of template with form
  18. Create dynamic arguments for url_for in Flask
  19. How do I escape % from python mysql query
  20. Using Flask, how do I modify the Cache-Control header for ALL output?
  21. How do you access an authenticated Google App Engine service from a (non-web) python client?
  22. Why are some mysql connections selecting old data the mysql database after a delete + insert?
  23. Python flask app routing in cpanel: can only access root url
  24. demystify Flask app.secret_key
  25. Flask broken pipe with requests
  26. Remove duplicates in list of object with Python
  27. How can I consume a WSDL (SOAP) web service in Python?
  28. SQLAlchemy ordering by count on a many to many relationship
  29. How do I run a long-running job in the background in Python
  30. ModuleNotFoundError: No module named ‘MySQLdb’

Leave a Comment