On Thu, 18 Apr 2002, Manish Mehta wrote:
> Hi
>
> I can Encrypt password in mysql using password() command. what is the way
> to decrypt the password.
Like most other password functions you'll find in the unix world
mysql's password function doesn't 'encrypt' a string, it generates a one
way hash. Meaning that there's nothing unique to decrypt; there may be
multiple strings which produce the same hash but the likelyhood of any
two strings (even very similar strings) generating the same hash is
microscopic. But in the context you're raising the answer is "there isn't
one".
-- TWZ
+-------------------------------------------------------------------------+
| Copyright 2001 by Terrence W. Zellers. All rights explicitly reserved. |
| email: [EMAIL PROTECTED] www.voicenet.com/~zellert/pub.key |
|-------------------------------------------------------------------------|
| A means of adding pith or humor to email: patent pending |
+-------------------------------------------------------------------------+
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
