mysql64位加密

[mysqld]
encryption_key_length = 256

from Crypto.Cipher import AES
from Crypto.Util.Padding import pad, unpad
import base64

# 密钥（需要确保密钥长度为16、24或32字节）
key = b'This is a key123'

# 加密
def encrypt(plaintext):
    cipher = AES.new(key, AES.MODE_CBC)
    ct_bytes = cipher.encrypt(pad(plaintext.encode(), AES.block_size))
    iv = base64.b64encode(cipher.iv).decode('utf-8')
    ct = base64.b64encode(ct_bytes).decode('utf-8')
    return iv + ':' + ct

# 解密
def decrypt(ciphertext):
    iv, ct = ciphertext.split(':')
    iv = base64.b64decode(iv)
    ct = base64.b64decode(ct)
    cipher = AES.new(key, AES.MODE_CBC, iv)
    pt = unpad(cipher.decrypt(ct), AES.block_size).decode()
    return pt

# 示例
plaintext = "Hello, World!"
ciphertext = encrypt(plaintext)
print("Encrypted:", ciphertext)
decrypted_text = decrypt(ciphertext)
print("Decrypted:", decrypted_text)