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

Grazie
Marco

Marco Cotroneo ha scritto:
> Salve!
> Esiste un modo "automatico" per criptare e decriptare i dati in
> database mysql?
>
> Grazie
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

== Quote from Marco Cotroneo (m.cot@italia.it)'s article
> Marco Cotroneo ha scritto:
> > Salve!
> > Esiste un modo "automatico" per criptare e decriptare i dati in
> > database mysql?
> >
> > Grazie
> 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


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

lark ha scritto:
> == Quote from Marco Cotroneo (m.cot@italia.it)'s article
>> Marco Cotroneo ha scritto:
>>> Salve!
>>> Esiste un modo "automatico" per criptare e decriptare i dati in
>>> database mysql?
>>>
>>> Grazie
>> 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
>
>
> yes, you have to do it manually as far as i know.

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


> --
> POST BY: lark with PHP News Reader ;o)

Marco Cotroneo wrote:
> lark ha scritto:
>> == Quote from Marco Cotroneo (m.cot@italia.it)'s article
>>> Marco Cotroneo ha scritto:
>>>> Salve!
>>>> Esiste un modo "automatico" per criptare e decriptare i dati in
>>>> database mysql?
>>>>
>>>> Grazie
>>> 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
>>
>>
>> yes, you have to do it manually as far as i know.
>
> 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
>
>
>> --

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.

On Wed, 24 Oct 2007 15:15:15 +0200, Marco Cotroneo wrote:
> Marco Cotroneo ha scritto:
>> Salve!
>> Esiste un modo "automatico" per criptare e decriptare i dati in
>> database mysql?
>>
>> Grazie
> 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?

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