Criptazione dati

[Marco Cotroneo]

Salve!
Esiste un modo "automatico" per criptare e decriptare i dati in
database mysql?

Grazie
Marco

[Marco Cotroneo]

Marco Cotroneo ha scritto:

Sorry I did not notice it was the english newgroup :)

Is there a way to crypting and decripting an entire mysql database?
I mean, should I manually encrypt decript data in my client application?

thx
Marco

[lark]

== Quote from Marco Cotroneo (m....@italia.it)'s article

yes, you have to do it manually as far as i know.
--
POST BY: lark with PHP News Reader ;o)

[Marco Cotroneo]

lark ha scritto:

That means if I use encode or decode functions, I need to encode or
decode on each insert update or select right?
Advice on which decryption function or method to use ?

For e.x. the encode functin need a second parameter to crypt the value,
is there a way to have the sencond parameter stored as a global variable?

thanks for any advice

Marco

[lark]

that's right. each time you access you'll have to run the function on
the value; however, you have many choices to pick from:

encode and decode (you mentioned)

DES_ENCRYPT(str[,{key_num|key_str}]) and
DES_DECRYPT(crypt_str[,key_str]) which requires that mysql is compiled
with ssl support

encrypt and md5 are a couple of others.

the second param in encode is a password param that you setup when you
run the encode function on the string. hope this helps out.

[Peter H. Coffin]

That depends on whom or what you want to hide the data from. If you want
to hide it from database user, you'll want to encrypt from within your
application.

--
When C++ is your hammer, everything looks like a thumb.
-- Steven M. Haflich