Encrypt File-Per-Table Tablespace¶
The file_per_table tablespace inherits the default schema encryption setting. Use the ENCRYPTION
clause in the in CREATE TABLE
statement to explicitly set the encryption.
mysql> CREATE TABLE ... ENCRYPTION='Y';
ENCRYPTION
clause. The ALTER TABLE
statement without the ENCRYPTION
clause does not change the encryption state.
mysql> ALTER TABLE ... ENCRYPTION='Y';
If the table_encryption_privilege_check
is enabled, the TABLE_ENCRYPTION_ADMIN
privilige is required to change the file_per_table encryption setting from the default schema encryption.
Get expert help¶
If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.
Last update:
2024-12-18