一，flask_mysql_connect

#flaskext.mysql   pip install flask-mysql  && pip install flask

from flask import Flask
from flaskext.mysql import MySQL
from flask import request



mysql = MySQL()
app = Flask(__name__)
app.config['MYSQL_DATABASE_USER'] = 'root'
app.config['MYSQL_DATABASE_PASSWORD'] = 'tan01001'
app.config['MYSQL_DATABASE_DB'] = 'web12306'
app.config['MYSQL_DATABASE_HOST'] = '192.168.17.131'
mysql.init_app(app)

@app.route("/")
def hello():
    return "Welcome to Python Flask App!"

@app.route("/Authenticate")
def Authenticate():
    username = request.args.get('UserName')
    password = request.args.get('Password')
    cursor = mysql.connect().cursor()
   # cursor.execute("SELECT * from User where user_pass='222'")
   # cursor.execute("SELECT * from User where Username='" + username + "' and Password='" + password + "'")
    cursor.execute("SELECT * from User where user_pass='" + username + "'")

    data = cursor.fetchone()
    if data is None:
     return "Username or Password is wrong"
    else:
     return "Logged in successfully"

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


#test http:
#http://127.0.0.1:5000/Authenticate?UserName=222&Password=admin