对mysql数据库数据进行加密

sqlINSERT INTO users (username, password) 
VALUES ('john_doe', AES_ENCRYPT('my_secret_password', 'encryption_key'));

sqlSELECT username, AES_DECRYPT(password, 'encryption_key') AS decrypted_password 
FROM users 
WHERE username = 'john_doe';

pythonimport pymysql
from cryptography.fernet import Fernet

# 生成密钥
key = Fernet.generate_key()
fernet = Fernet(key)

# 连接到MySQL数据库
conn = pymysql.connect(host='localhost', user='user', password='password', db='mydatabase')
cursor = conn.cursor()

# 加密数据
password = 'my_secret_password'
encrypted_password = fernet.encrypt(password.encode())

# 插入加密数据
cursor.execute("INSERT INTO users (username, password) VALUES (%s, %s)", ('john_doe', encrypted_password))
conn.commit()

# 解密数据
cursor.execute("SELECT password FROM users WHERE username = %s", ('john_doe',))
result = cursor.fetchone()
decrypted_password = fernet.decrypt(result[0]).decode()

print(decrypted_password)

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