I am trying to encrypt some columns in mysql using mysql encryptor AES_ENCRYPT
SELECT TO_BASE64(AES_ENCRYPT('[email protected]', '123'));
‘123’ is secret key here.
After executing this command I can see it in logs and secret key is shown in logs.
Which means that if I give access to my database to any DBA he can easily decrypt data.
Is there any way to fix it?
I am trying to fix AES_ENCRYPT command secret_key appearing in logs