mysql存储密码类型

import hashlib
import mysql.connector
import os

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

cursor = db.cursor()

# 用户注册
def register(username, password):
    salt = os.urandom(16).hex()
    hashed_password = hashlib.sha256((password + salt).encode()).hexdigest()
    query = "INSERT INTO users (username, password, salt) VALUES (%s, %s, %s)"
    cursor.execute(query, (username, hashed_password, salt))
    db.commit()

# 用户登录
def login(username, password):
    query = "SELECT password, salt FROM users WHERE username = %s"
    cursor.execute(query, (username,))
    result = cursor.fetchone()
    if result:
        stored_password, salt = result
        hashed_password = hashlib.sha256((password + salt).encode()).hexdigest()
        if hashed_password == stored_password:
            print("登录成功")
        else:
            print("密码错误")
    else:
        print("用户不存在")

# 示例调用
register("user1", "password123")
login("user1", "password123")

cursor.close()
db.close()