Using MySQL in Flask

Question

I want to know more about Flask, kindly share some codes on how to access a MySQL DB? There have been records showing how to connect to SQLite but not on MySQL.

Answer 1

For achieving your goal, you need to work with a package named Flask-MySQL package. First, install the module with the pip command:

pip install flask-mysql

After that, you need to combine 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 do the connection and cursor objects and can able to execute raw queries:

conn = mysql.connect()

cursor =conn.cursor()

cursor.execute("SELECT * from User")

data = cursor.fetchone()

If you are newbie and want to explore more about Python, then learn python from the below video tutorial: