Python Flask – Conexión a base de datos MySQL

pip install flask-mysql

from flask import Flask
from flaskext.mysql import MySQL

app = Flask(__name__)

mysql = MySQL()
app.config['MYSQL_DATABASE_USER'] = 'usuario'
app.config['MYSQL_DATABASE_PASSWORD'] = 'contraseña'
app.config['MYSQL_DATABASE_DB'] = 'mi_basededatos'
app.config['MYSQL_DATABASE_HOST'] = 'localhost'
mysql.init_app(app)

@app.route('/')
def index():
    conn = mysql.connect()
    cursor = conn.cursor()
    cursor.execute('SELECT * FROM tabla')
    resultados = cursor.fetchall()
    conn.close()
    return str(resultados)

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