mysql 存密码

import hashlib
import os

def generate_salt():
    return os.urandom(16).hex()

def hash_password(password, salt):
    return hashlib.sha256((password + salt).encode()).hexdigest()

# 用户注册
def register_user(username, password):
    salt = generate_salt()
    hashed_password = hash_password(password, salt)
    # 将 username, hashed_password, salt 存入数据库
    print(f"User {username} registered with hashed password {hashed_password} and salt {salt}")

# 用户登录
def login_user(username, password):
    # 从数据库中获取用户的 hashed_password 和 salt
    hashed_password_db = "hashed_password_from_db"
    salt_db = "salt_from_db"
    
    if hash_password(password, salt_db) == hashed_password_db:
        print(f"User {username} logged in successfully")
    else:
        print("Invalid credentials")

# 示例调用
register_user("user1", "password123")
login_user("user1", "password123")