mysql怎么验证密码

import mysql.connector
import hashlib

def get_salt_and_hash(username):
    conn = mysql.connector.connect(user='your_user', password='your_password', host='your_host', database='your_database')
    cursor = conn.cursor()
    query = "SELECT salt, password_hash FROM users WHERE username = %s"
    cursor.execute(query, (username,))
    result = cursor.fetchone()
    cursor.close()
    conn.close()
    return result

def verify_password(username, input_password):
    salt_and_hash = get_salt_and_hash(username)
    if salt_and_hash:
        salt, stored_hash = salt_and_hash
        input_password_hash = hashlib.sha256((input_password + salt).encode()).hexdigest()
        return input_password_hash == stored_hash
    return False

# 示例使用
username = 'example_user'
input_password = 'example_password'
if verify_password(username, input_password):
    print("密码验证成功")
else:
    print("密码验证失败")