MYSQL with PII Security Encryption

How to enable Mysql PII Security for some rows at DB level.

I heard it can be implemented without using Application  calls & can be enabled directly at the DB level.
Siva PrasadAdminAsked:
Who is Participating?
 
Steve BinkCommented:
There is no encryption of that sort in MySQL.  Your options are:

1) Encrypt information in your code.  Having the application do the encryption is generally safer and more efficient.  For example, you don't need to transfer the encryption key or target data.

2) Use MySQL's encryption functions to encrypt data as needed.  While this is certainly possible, I would argue it to be less efficient than app-based encryption.  Also, it stores the key with the lock - never a good security scenario.  See http://thinkdiff.net/mysql/encrypt-mysql-data-using-aes-techniques for a description of how this is done.

One other possibility is to encrypt the file system, but that does not really protect against software access, only physical access to the drive.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.