How to decrypt a mariadb database or change the encryption key?
1
vote
0
answers
81
views
I successfully encrypted my MariaDB database using
file_key_management
and following this guide . Now I'd like to change the encryption key and suppose I need to decrypt the database first, before I can apply a new one.
ALTER TABLE mytable ENCRYPTED=NO;
I was able to decrypt all tables using this command. I was also able to decrypt also the system tables using the SET GLOBAL
command and the server now starts unencrypted without a key.
With a new key, however, I still get an error message saying wrong decryption key. Why does the database still remember the old key and how to set a new one?
SET GLOBAL innodb_encrypt_tables=OFF;
SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION
Asked by NablaDelta
(11 rep)
May 2, 2025, 01:13 PM
Last activity: May 3, 2025, 11:27 AM
Last activity: May 3, 2025, 11:27 AM