Encrypted databases?

[php_rules]

Hi, I was just wondering if its possible to encrypt databases? I'm sure I could put a hack in to encrypt the data going in and decrypt it coming out, but is it implemented in mysql ?

[Sentinel]

MySQL :: MySQL 5.1 Reference Manual :: 11.11.2 Encryption and Compression Functions

It's implemented in mysql - you need to use the AES_DECRYPT() and AES_ENCRYPT() - or DES_DECRYPT() and DES_DECRYPT() functions in your query strings - it's only 128bit rijandel, but its better than nothing - If i were you I would look at something stronger, or make your own function to double or triple encrypt it - that way it uses a lot more cpu, but it is far more safe.

[php_rules]

, I'll have to have a shot at making all my databases encrypted now, should be a fun project for a Sunday afternoon - It's going to be pretty easy to change though - I have one query function that gets re-used, so I can just add the decrypt to the read and the encrypt to the write (hopefully!!).