I have been trying to figure out how to transparent data encryption my Mysql Database for weeks. Time is running out. I need help.. I am using xampp and possibly going to turn to Postgres.
If TDE is not possible for xampp mysql, then is there a way to lock the database say if I were to connect through MySQL Workbench, it will show error or prompt for password?
MySQL does not suport TDE. You have to do encryption in your application.