flask_mysql.py

import sys
from flask import Flask, jsonify, request
from keras.datasets import mnist
import MySQLdb

app = Flask(__name__)


@app.route("/", methods=["GET", "POST"])
def hello():
    db = MySQLdb.connect(user='myhu', password='password', host='98.111.105.254', database='w3schools')
    cursor = db.cursor()

    query_string = "SELECT customerName FROM customers WHERE country = %s"
    cursor.execute(query_string, (request.args.get("country"),))

    data = cursor.fetchall()

    db.close()
    return jsonify(data)


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