如何在CentOS中加密已有的mariadb表？

openssl rand -base64 32 > /path/to/keyfile.key

chmod 600 /path/to/keyfile.key

SET GLOBAL innodb_encrypt_tables = ON;
SET GLOBAL innodb_default_encryption_key_id = 1;
SET GLOBAL innodb_encryption_threads = 4;
SET GLOBAL innodb_encrypt_log = ON;
SET GLOBAL innodb_encryption_rotation_iops = 100;
SET GLOBAL innodb_encryption_rotation_pages_per_batch = 10;

CREATE ENCRYPTION KEYFILE '/path/to/keyfile.key';

CREATE ENCRYPTION KEYFILE '/path/to/keyfile.key' IDENTIFIED BY 'encryption_key_password';

ALTER INSTANCE ROTATE INNODB MASTER KEY;

SELECT NAME, ENCRYPTION_SCHEME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION;