Encrypting the mysql database

1

I’d like to use an encrypted mysql database with OpenMRS, or only encrypt a few designated tables to ensure privacy of PPI. OpenMRS 2.3.0 is used on ubuntu 16.04. Both the OpenMRS application and database will be running on the same machine. Any help with setup is much appreciated.

2

@levine you can have a look at this though i would discourage encrypting the entire openmrs DB…

you can encrypt certain tables with sensitive data …

3

and some insights here Database encryption in Java - GeeksforGeeks