mysql 如何存储密码

import bcrypt
import mysql.connector

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

# 用户注册
def register(username, password):
    # 对密码进行哈希处理
    hashed_password = bcrypt.hashpw(password.encode('utf-8'), bcrypt.gensalt())
    
    # 将用户名和哈希后的密码插入数据库
    sql = "INSERT INTO users (username, password) VALUES (%s, %s)"
    cursor.execute(sql, (username, hashed_password))
    db.commit()

# 用户登录
def login(username, password):
    # 查询数据库中的哈希密码
    sql = "SELECT password FROM users WHERE username = %s"
    cursor.execute(sql, (username,))
    result = cursor.fetchone()
    
    if result:
        stored_password = result[0]
        # 验证密码
        if bcrypt.checkpw(password.encode('utf-8'), stored_password):
            print("登录成功")
        else:
            print("密码错误")
    else:
        print("用户名不存在")

# 示例调用
register("testuser", "testpassword")
login("testuser", "testpassword")

# 关闭数据库连接
cursor.close()
db.close()