mysql取消明文密码

pip install bcrypt

import bcrypt
import mysql.connector

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

cursor = db.cursor()

# 用户注册时，对密码进行哈希处理
password = "user_password".encode('utf-8')
hashed_password = bcrypt.hashpw(password, bcrypt.gensalt())

# 将哈希后的密码存储到数据库
sql = "INSERT INTO users (username, password) VALUES (%s, %s)"
cursor.execute(sql, ("username", hashed_password))
db.commit()

# 用户登录时，验证密码
input_password = "user_input_password".encode('utf-8')
sql = "SELECT password FROM users WHERE username = %s"
cursor.execute(sql, ("username",))
result = cursor.fetchone()

if result and bcrypt.checkpw(input_password, result[0]):
    print("密码正确")
else:
    print("密码错误")