How to store sensitive data in database

1. What is the best way to store sensitive data in database?
2. How to store sensitive data in SQL database?
3. How do you store sensitive data securely?

What is the best way to store sensitive data in database?

For example, frequently used sensitive data is best stored on a high-speed medium, such as an HDD or SSD. If the storage media are in a data center, they are much easier to monitor for security and unauthorized access than if the storage media are in a cloud environment.

How to store sensitive data in SQL database?

For storage of encrypted data, you could use a BLOB field, and use MySQL's built in encryption functions. Example: update mytable set myfield = AES_ENCRYPT('some value', SHA2('your secure secret key', 512)); If you prefer to do the encryption/decryption in the application code, take a look at PHP's Mcrypt functions.

How do you store sensitive data securely?

The key to a good encryption strategy is using strong encryption and proper key management. Encrypt sensitive data before it is shared over untrusted networks (ex. Encrypted Email, Encrypted file storage). Cloud Misuse - Storing data in the Cloud equates to storing your data on someone else's computer.