网站如何链接数据库mysql

from flask import Flask, request, jsonify
import mysql.connector

app = Flask(__name__)

# 数据库配置
db_config = {
    'host': 'localhost',
    'user': 'root',
    'password': 'password',
    'database': 'mydatabase'
}

@app.route('/add_user', methods=['POST'])
def add_user():
    data = request.get_json()
    name = data['name']
    email = data['email']

    conn = mysql.connector.connect(**db_config)
    cursor = conn.cursor()
    query = "INSERT INTO users (name, email) VALUES (%s, %s)"
    cursor.execute(query, (name, email))
    conn.commit()
    cursor.close()
    conn.close()

    return jsonify({'message': 'User added successfully'})

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