php - How to encrypt existing MySQL database? -

Our company needs to collect confidential data before sending us for PHP development. They are asking us what is the best way to do this kind of situation.

The requirement is that the data should be decrypted.

Is this a free / commercial tool for doing this or can it be done by PHP or Linux command?

MySQL is already reversible, such as AES_ENCRYPT ().

You can scramble sensitive data based on column-by-column, as follows:

  Update something SET sensitive_column = AES_ENCRYPT (sensitive_column, 'password');   
 This string works at least for data.