How to Encrypt & Decrypt Key data stored in MySQL via Php

[WorldNews]

Hi,

We want to Encrypt the values for few Key data before storing them in the MySQL DB and
then Decrypt them when reading them, so that if someone hacks the data in the MySQL DBs
they see nothing but useless gibrish.

What is the best Php/MySQL method for Encrypting/Decrypting Data stored in a MySQL DB?

Regards,
Dean

[force]

Here’s a few resources to help get you started:

https://dev.mysql.com/doc/refman/5.5/en/encryption-functions.html

Thinkdiff

http://techpad.co.uk/content.php?sid=82

http://i.amniels.com/mysql-database-encryption-using-public-private-keys

[WorldNews]

Yes, of course I can access these same links by doing a search.

But what I am hoping to get from my Question posted here is what do Experts here with real world experience of this important subject matter
think is the best method for Encrypting & Decrypting Data stored in a MySQL DB?

@Force_Flow

Here’s a few resources to help get you started:

https://dev.mysql.com/doc/refman/5.5/en/encryption-functions.html

http://thinkdiff.net/mysql/encrypt-mysql-data-using-aes-techniques/

http://techpad.co.uk/content.php?sid=82

http://i.amniels.com/mysql-database-encryption-using-public-private-keys

[logic_earth]

There is no best. And we cannot tell you which to use or not to use because we don’t know the full requirements. Do the research you need to do. If you have a problem then ask for help.