MySQL Encrypt / Decrypt datatype

[Jassim Rahma]

Hi, I would like to ask how can I encrypt a datatype in MySQL? I have an employees database and need to encrypt the salary field? Thanks, Jassim[^]

Technology News @ www.JassimRahma.com

[Kornfeld Eliyahu Peter]

Encrypt inside the database? Why?

Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.

[Richard Deeming]

Is Google not working where you are? MySQL :: MySQL 5.5 Reference Manual :: 12.13 Encryption and Compression Functions[^]

---

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

[Jassim Rahma]

because it's auditor requirement to have the salary field encrypted

Technology News @ www.JassimRahma.com

[david_smith01]

To encrypt & decrypt mysql data we will use AES_ENCRYPT() and AES_DECRYPT() functions. These functions used the official AES (Advanced Encryption Standard) algorithm & encode data with a 128-bit key length. 128 bits is much faster and secure enough for most purposes ....................... Parse alternatives

[jschell]

Jassim Rahma wrote:

because it's auditor requirement to have the salary field encrypted

Certainly not the stupidest thing I have heard but it certainly ranks up there