Is it possible to encrypt a MySQL database with a certificate, so that only its content can be viewed on the server where the certificate is installed?
The idea is to code the entire database at once, so that you do not have to modify query by query. I know that in SQL Server it is possible, that is why I wonder if it is possible in MySQL.
Edit 1
I have been searching the internet and I have seen that there is a way to do it for what I am looking for, TDE. Is it the right thing?
Edit 2
After making a battery of tests, I see that the database must be in MySQL and the tables in InnoDB, which is correct, they are like this, but when I launch the command to code the table, I see an error in the plugin, which if it's loaded, but it seems not correctly.
/* Consulta de encriptacion de tabla existente */
ALTER TABLE tabla ENCRYPTION='Y';
I'm accessing from a root user to launch the queries, but that does not seem to be the problem (but, it informs you)