mysql中如何加密存储

import mysql.connector
from Crypto.Cipher import AES
import base64

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

cursor = db.cursor()

# AES加密函数
def encrypt_aes(data, key):
    cipher = AES.new(key.encode('utf-8'), AES.MODE_EAX)
    nonce = cipher.nonce
    ciphertext, tag = cipher.encrypt_and_digest(data.encode('utf-8'))
    return base64.b64encode(nonce + ciphertext).decode('utf-8')

# AES解密函数
def decrypt_aes(encrypted_data, key):
    encrypted_data = base64.b64decode(encrypted_data)
    nonce = encrypted_data[:16]
    ciphertext = encrypted_data[16:]
    cipher = AES.new(key.encode('utf-8'), AES.MODE_EAX, nonce=nonce)
    return cipher.decrypt(ciphertext).decode('utf-8')

# 加密并存储数据
data_to_encrypt = "Sensitive information"
encryption_key = "yourencryptionkey"
encrypted_data = encrypt_aes(data_to_encrypt, encryption_key)
cursor.execute("INSERT INTO yourtable (encrypted_data) VALUES (%s)", (encrypted_data,))
db.commit()

# 读取并解密数据
cursor.execute("SELECT encrypted_data FROM yourtable WHERE id = %s", (1,))
result = cursor.fetchone()
decrypted_data = decrypt_aes(result[0], encryption_key)
print(decrypted_data)

# 关闭数据库连接
cursor.close()
db.close()