I just tried and it appears the functions DO NOT work in version 3.23
From: "Neil Tompkins" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: FW: Re: MD5()
Date: Mon, 12 Mar 2007 09:28:27 +
I thought the DES_ENCRYPT/DES_DECRYPT functions were released in mysql
v
I thought the DES_ENCRYPT/DES_DECRYPT functions were released in mysql
version 4 however they work with my version of mySQL 3.23 ?
Neil
From: "Neil Tompkins" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: FW: Re: MD5()
Date: Sat, 10 Mar 2007 18:24:19 +
Strange
Strange the DES_ENCRYPT/DES_DECRYPT functions work with my version of mySQL
3.23
From: "Neil Tompkins" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: MD5()
Date: Sat, 10 Mar 2007 18:20:43 +
DES_ENCRYPT/DES_DECRYPT appears to be what we
DES_ENCRYPT/DES_DECRYPT appears to be what we require.
Thanks
Neil
From: "Mogens Melander" <[EMAIL PROTECTED]>
To: "Neil Tompkins" <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: MD5()
Date: Sat, 10 Mar 2007 12:19:53 +0100 (CET)
Or you might wa
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Before you implement anything, I would do a lot of research about
encryption. No offense, but from your question, it is clear that you know
next to nothing about encryption. That's fine. A few years ago, I was the
exact same way. However, enc
Or you might want to take a look at DES_ENCRYPT/DES_DECRYPT
funktions in the mysql manual.
On Sat, March 10, 2007 11:18, Ian P. Christian wrote:
> Neil Tompkins wrote:
>> I'm looking to use MD5() to encrypt credit card numbers. How do I
>> unencrypt this when reading the value ?
>>
>
> you can't.
Neil Tompkins wrote:
The problem I have is our mysql database version is 3.23 and we are not
in a position to upgrade.
Because you are unlikely to be selecting on this data directly, you
could use functions of whatever language you're using to connect to the
database... for example if you're
The problem I have is our mysql database version is 3.23 and we are not in a
position to upgrade.
From: "Ian P. Christian" <[EMAIL PROTECTED]>
To: Neil Tompkins <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: MD5()
Date: Sat, 10 Mar 2007 10:24:45 +
Neil
Neil Tompkins wrote:
What do you recommend I use ?
http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html
That should help you.
However... keep in mind that if your application is likely to be
accessing this data all the time anyway, if someone compromises your
database, chances a
What do you recommend I use ?
From: "Ian P. Christian" <[EMAIL PROTECTED]>
To: Neil Tompkins <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: MD5()
Date: Sat, 10 Mar 2007 10:18:41 +
Neil Tompkins wrote:
I'm looking to use MD5() to encrypt cre
Neil Tompkins wrote:
I'm looking to use MD5() to encrypt credit card numbers. How do I
unencrypt this when reading the value ?
you can't.
Google for MD5, or better still look at wikipedia, I'm sure they will
have something
--
Ian P. Christian ~ http://pookey.co.uk
--
MySQL General Mailin
Egor Egorov wrote:
"Andy B" <[EMAIL PROTECTED]> wrote:
hi...
what would be the best field type and length for an md5 encrypted password sort of thing??
You can store it in the CHAR(32) column (or VARCHAR(32)).
Or for binary MD5 (and not the hex version) a TINYBLOB(16) should also
be OK.
"Andy B" <[EMAIL PROTECTED]> wrote:
> hi...
>
> what would be the best field type and length for an md5 encrypted password sort of
> thing??
You can store it in the CHAR(32) column (or VARCHAR(32)).
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is spo
Hi Steven,
while the general idea sounds not to bad, I guess the "bad guess" would just
use a undecrypt function wich they either develop themself or get from
somewhere.
Best regards
Nils Valentin
Tokyo/Japan
2003年 8月 14日 木曜日 03:07、Lefevre, Steven さんは書きました:
> Hey folks -
>
> While contempl
2003年 8月 14日 木曜日 12:50、Nils Valentin さんは書きました:
> Hi Steven,
>
> while the general idea sounds not to bad, I guess the "bad guess" would
I meant the "bad guys" - what a silly typo ;-)
> just use a undecrypt function wich they either develop themself or get from
> somewhere.
Best regards
Nils
While I understand the concern, it shouldn't be any easier for a hacker to
see the raw text of your PHP files than to get directly to your database
files. Neither is normally permitted by the web server. So if he somehow can
get in and get one, why not the other?
That said, if it makes you fee
> -Original Message-
> From: Joshua J.Kugler [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 20, 2002 4:30 PM
> To: Kiss Dániel; [EMAIL PROTECTED]
> Subject: Re: MD5
>
> If you are running Linix, at the prompt type:
>
> md5sum filename
>
> I'm sure
If you are running Linix, at the prompt type:
md5sum filename
I'm sure you can get md5sum for other Unices as well.
j- k-
On Thursday 20 June 2002 13:00, Kiss Dániel wrote:
> Hi everyone,
>
> Can anyone tell me how to create an MD5 checksum on a file.
> I tried to do this by using the
On Tuesday 09 April 2002 2:13 pm, Andrew Hazen wrote:
> Hi,
> Can I use the MD5 function in the where clause, as in:
>
> Select * from table where md5(column)=value
>
I see no reason why not but note that you are likely MUCH better off storing
column as an MD5 hash, computing the MD5 of val
19 matches
Mail list logo
