给mysql表中密码加密

import mysql.connector
import hashlib
import os

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

cursor = db.cursor()

# 创建用户表（如果还没有）
cursor.execute("""
CREATE TABLE IF NOT EXISTS users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(255) NOT NULL,
    password_hash VARCHAR(255) NOT NULL,
    salt VARCHAR(255) NOT NULL
)
""")

# 注册新用户
def register_user(username, password):
    salt = os.urandom(16).hex()  # 生成盐
    password_hash = hashlib.sha256((password + salt).encode()).hexdigest()  # 计算加盐哈希
    cursor.execute("INSERT INTO users (username, password_hash, salt) VALUES (%s, %s, %s)", (username, password_hash, salt))
    db.commit()

# 示例：注册一个新用户
register_user("testuser", "testpassword")

# 关闭连接
cursor.close()
db.close()