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';

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.

Community Forum Get a Percona Expert

---

Last update: 2023-09-01