#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2000
    Posts
    9
    Rep Power
    0
    Hi there. I use php3 and mysql. I've got a table filled with registered users. Their passwords are encrypted using the PASSWORD('') function of mysql. But now I want an option: "I forgot my password, please send me my password". Can I decrypt the passwords???

    Please help!

    Thanks in advance,

    Marc
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    No. The mysql password() function does not have a complementary decrypt function. This is the same function used to encrypt passwords in the mysql permissions table so it wouldn't be a good idea to make a decryption function available

    If you need to store encrypted passwords then use the php encrypt and decrypt functions. (I think encrypt is right, but check decrypt first to see what is it's complement).
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Posts
    6
    Rep Power
    0
    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by rod k:
    If you need to store encrypted passwords then use the php encrypt and decrypt functions. (I think encrypt is right, but check decrypt first to see what is it's complement). [/quote]

    Nope. You are thinking of Encode() and Decode () which are used for stream encryption.
    There is no reverse for encrypt(). You would need a password cracker or some such thing.
    (If such functionality is required, most people just store both the crypted and un-crypted forms in their database, and use whichever one they need).


    ------------------
    -Erik

Similar Threads

  1. Postgres ignores passwords
    By sfncook in forum PostgreSQL Help
    Replies: 1
    Last Post: December 19th, 2003, 07:14 PM
  2. Replies: 3
    Last Post: October 7th, 2003, 06:37 AM
  3. Outlook and email passwords
    By jrivesj in forum Beginner Programming
    Replies: 3
    Last Post: June 19th, 2003, 08:12 PM
  4. Hashing passwords
    By JMM in forum Security and Cryptography
    Replies: 8
    Last Post: September 4th, 2001, 06:27 PM
  5. Mod_auth_mysql encrypted passwords
    By Rebel in forum Apache Development
    Replies: 1
    Last Post: March 2nd, 2001, 04:32 AM

IMN logo majestic logo threadwatch logo seochat tools logo