#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Posts
    70
    Rep Power
    15
    Hi,

    I use the PASSWORD function to encrypt the password provided by the users in a registration form in my site.

    The problem is that the password is encrypted and stored. I am not able to decrypt it whenever I require it.With use of Password func how do I decrypt it?

    Thanks in advance
  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
    There is no complement to the password() function for decrypting.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Posts
    5
    Rep Power
    0
    Instead of decrypting password,
    you can encrypt another password by
    using PASSWORD() .
    ex) select PASSWORD('another_one');

    Or, check the rows what is correct.
    ex) select id from MEMBER_TABLE where password = PASSWORD('another_one');
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Oelstykke, Sjaelland, Denmark
    Posts
    1
    Rep Power
    0
    Hi Paxjesus and others.

    I'm a newbie to mysql, php and so on, but I'm getting the basic idea, BUT..
    is it then tru if the simpel line:
    PASSWORD('another_one');
    Encrypts the "another_one" string?
    how can this be?
  8. #5
  9. 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
    password() is just a built in function of mysql that uses a propriety system to encrypt the string passed. No magic to it.

Similar Threads

  1. MySQL password problems NOT root
    By braveheart in forum MySQL Help
    Replies: 2
    Last Post: February 15th, 2004, 09:18 AM
  2. password generation on user auth.
    By nacho_c in forum PHP Development
    Replies: 14
    Last Post: January 16th, 2004, 05:55 AM
  3. Replies: 1
    Last Post: January 7th, 2004, 07:41 PM
  4. want password protect?
    By CaptinKirk in forum Beginner Programming
    Replies: 4
    Last Post: December 18th, 2003, 01:00 PM
  5. changing password in a file
    By pinak in forum PHP Development
    Replies: 1
    Last Post: September 30th, 2003, 10:31 PM

IMN logo majestic logo threadwatch logo seochat tools logo