用户登录代码mysql

import mysql.connector

def login(username, password):
    try:
        # 连接到MySQL数据库
        db = mysql.connector.connect(
            host="localhost",
            user="yourusername",
            password="yourpassword",
            database="yourdatabase"
        )
        cursor = db.cursor()

        # 查询用户表
        query = "SELECT * FROM users WHERE username = %s AND password = %s"
        cursor.execute(query, (username, password))

        # 获取查询结果
        result = cursor.fetchone()

        if result:
            print("登录成功")
        else:
            print("用户名或密码错误")

        cursor.close()
        db.close()

    except mysql.connector.Error as err:
        print(f"数据库错误: {err}")

# 示例调用
login("user1", "password1")