From: Mogens Melander
Date: August 18 2007 3:19pm
Subject: Re: Password storage
List-Archive: http://lists.mysql.com/mysql/208622
Message-Id: <2246.90.184.17.152.1187450382.squirrel@mail.fumlersoft.dk>
MIME-Version: 1.0
Content-Type: text/plain;charset=utf-8
Content-Transfer-Encoding: 8bit


On Sat, August 18, 2007 15:53, C K wrote:
> Thanks to all,
> but the problem is that I am using external programs to insert data and I
> can't use MySQL functions directly. Can I call/implement such type of
> functions using MS Access 2003?

MD5() is not an encryption function. The MySQL manual states:

<QUOTE>

MD5(str)

Calculates an MD5 128-bit checksum for the string. The value
is returned as a binary string of 32 hex digits, or NULL if
the argument was NULL. The return value can, for example,
be used as a hash key.

mysql> SELECT MD5('testing');
        -> 'ae2b1fca515949e5d54fb22b8ed95575'

This is the “RSA Data Security, Inc. MD5 Message-Digest Algorithm.”

</QUOTE>


You might want to look at ENCODE() and DECODE() functions. Again from the manual:

<QUOTE>

DECODE(crypt_str,pass_str)

Decrypts the encrypted string crypt_str using pass_str as
the password. crypt_str should be a string returned from ENCODE().

ENCODE(str,pass_str)

Encrypt str using pass_str as the password.
To decrypt the result, use DECODE().

The result is a binary string of the same length as str.

The strength of the encryption is based on how good the random
generator is. It should suffice for short strings.

</QUOTE>

These are all functions you use in your sql statement, so yes. They can be
used in MS Access.

-- 
Later

Mogens Melander
+45 40 85 71 38
+66 870 133 224



-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.