mysql存储登录密码

import hashlib
import mysql.connector
import os

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

# 生成盐值
salt = os.urandom(16).hex()

# 计算哈希
password = "user_password"
hashed_password = hashlib.sha256((password + salt).encode()).hexdigest()

# 存储数据
sql = "INSERT INTO users (username, salt, password_hash) VALUES (%s, %s, %s)"
val = ("username", salt, hashed_password)
cursor.execute(sql, val)
db.commit()

cursor.close()
db.close()

import hashlib
import mysql.connector

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

# 获取用户输入的密码
input_password = "user_input_password"

# 获取盐值和存储的哈希值
cursor.execute("SELECT salt, password_hash FROM users WHERE username = %s", ("username",))
result = cursor.fetchone()
salt = result[0]
stored_hash = result[1]

# 计算哈希
hashed_input_password = hashlib.sha256((input_password + salt).encode()).hexdigest()

# 比较哈希
if hashed_input_password == stored_hash:
    print("密码正确")
else:
    print("密码错误")

cursor.close()
db.close()