MariaDB - How to confirm Data at Rest has been encrypted?

461 Views Asked by At

I've just installed MariaDB 10.5.5 on Windows Server 2019 and have enabled the file_key_management plugin (keyfile is not encrypted (but will be)). I need to provide proof that the data is in fact encrypted, and have tried the recommendations from the two other posts I found here (First post and second post), specifically using strings C:/[path to my database data]/testdb.ibd | grep "abc" but haven't had any success (I get Syntax errors that there's a problem and check the Documentation (which I did)). I did check the INNODB_Tablespaces_encryption table and it's showing my table has Encryption_scheme = 1, so I'm assuming I am OK, but need to provide screenshots / proof of the encryption. Any help or ideas would be appreciated. Chris

0

There are 0 best solutions below