Skip to content
Percona Software for MySQL Documentation

For help, click the link below to get free database assistance or contact our experts for personalized support.

Get help from Percona

Encrypt system tablespace

By default, the system tablespace, which contains the system database and the data dictionary tables, is unencrypted. To change the encryption requires the CREATE TABLESPACE privilege on all tables in the instance.

In an ALTER TABLESPCE statement, add the ENCRYPTION option with the tablespace name to enable encryption.

mysql> ALTER TABLESPACE mysql ENCRYPTION='Y';
Disable encryption by setting the ENCRYPTION option to ‘N”.

mysql> ALTER TABLESPACE mysql ENCRYPTION='N';
Last update: 2023-09-01