sql数据库密码查询

import hashlib
import mysql.connector

# 连接到数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 假设用户输入的用户名和密码
input_username = "exampleuser"
input_password = "examplepassword"

# 查询用户信息
query = "SELECT password_hash, salt FROM users WHERE username = %s"
cursor.execute(query, (input_username,))
result = cursor.fetchone()

if result:
    password_hash, salt = result
    # 使用相同的盐值对输入的密码进行哈希处理
    input_password_hash = hashlib.sha256((input_password + salt).encode()).hexdigest()
    # 比较哈希值
    if input_password_hash == password_hash:
        print("登录成功")
    else:
        print("密码错误")
else:
    print("用户不存在")

cursor.close()
db.close()