python 连接mysql数据库

from flask import Flask, render_template, request, redirect, url_for, session
from flask_mysqldb import MySQL
import MySQLdb.cursors
import pymysql.cursors
app = Flask(__name__)
app.config['DEBUG']=True

@app.route('/')
def hello_world():
    return 'Hello app !202212'

@app.route("/add/user", methods=["GET", "POST"])
def add_user():
    if request.method == 'GET':
        return render_template("add_user.html")
    username = request.form.get("user")
    password = request.form.get("pwd")
    mobile = request.form.get("mobile")

    # 1.连接MySQL
    conn = pymysql.connect(host="127.0.0.1", port=3306, user='root', password="123456", charset='utf8', db='LOGIN')
    cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
    # 2.提交SQL语句
    sql = "insert into admin(username,password,mobile) values(%s,%s,%s)"
    cursor.execute(sql, [username, password, mobile])
    conn.commit()
    # 3.关闭SQL连接
    cursor.close()
    conn.close()
    return "连接成功"

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