Geek asks and answers

How to encrypt an existing MySQL database?

Our company must first crossbreed sensitive data before sending it to us for PHP development. They ask us what is the best approach to this situation.

The requirement is that the data be decrypted.

Is there a free / commercial tool for this, or can it be done only with the help of a PHP or Linux command?

+5
source share
2 answers

MySQL already includes reversible encryption functions such as AES_ENCRYPT ().

You can scramble sensitive data on a per-post basis as follows:

UPDATE SomeTable SET sensitive_column = AES_ENCRYPT(sensitive_column, 'password');

This works as a minimum for string data.

+6
source

, , . , , , . , , . http://en.wikipedia.org/wiki/Data_masking

0

More articles:


All Articles