0

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

user2337160
  • 41
  • 1
  • 5
  • 1
    Those are UNIX commands and are unlikely to work on Windows. You'll need to find a Windows version of those commands that search for printable strings in the database files.Additionally, you'll need string that is known to be in the table (e.g. insert `"Hello world"` into an encrypted table and then try to find that in the file). – markusjm May 21 '21 at 12:06
  • Ahh - that makes sense @markusjm - thanks for your time. Chris – user2337160 May 22 '21 at 17:03

0 Answers0