Page 1 of 1
Database Encryption
Posted: Sat Feb 13, 2016 11:14 pm
by vdTOG
How can I encrypt the content of my databases?
I don't want to keep the files in plain text on the server.
Thank you
Re: Database Encryption
Posted: Tue Feb 16, 2016 4:34 am
by prupert
Table-level encryption is possible with MariaDB 10.1. See
https://mariadb.com/kb/en/mariadb/data- ... ncryption/
If you do not want to use this feature, or if you are (most likely) on an older MySQL/MariaDB version you could use an encrypted file system.
(You should probably not forget to encrypt backups as well.)
If you only need some specific content encrypted (i.e. SSN, credit card data), and this does not need to be indexable/searchable, you could also opt for ad-hoc encryption of cell data, where the logic of encryption/decryption is implemented in your application.