mysql怎么给字段加密

-- 创建一个表
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(255),
    password VARBINARY(255)
);

-- 插入加密后的密码
INSERT INTO users (username, password) VALUES ('user1', AES_ENCRYPT('password123', 'encryption_key'));

-- 查询并解密密码
SELECT username, AES_DECRYPT(password, 'encryption_key') AS decrypted_password FROM users;

import mysql.connector
import OpenSSL

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

cursor = db.cursor()

# 加密数据
data = "password123"
key = OpenSSL.rand.bytes(32)
iv = OpenSSL.rand.bytes(16)
cipher = OpenSSL.crypto.Cipher(alg='aes_256_cbc', key=key, iv=iv, op=1)
encrypted_data = cipher.update(data.encode()) + cipher.final()

# 插入加密后的数据
cursor.execute("INSERT INTO users (username, password) VALUES (%s, %s)", ('user1', encrypted_data))

db.commit()
db.close()