How to recover lost password of wordpress (Local Host)

Discussion in 'WordPress' started by GAdsense, Jul 18, 2008.

0
  1. #1
    I lost my login details as it has been quite some time now since I last accessed it. I need to use wordpress, so I also need access to admin area.

    Hope someone can help.
     
    GAdsense, Jul 18, 2008 IP
  2. infogle

    infogle Prominent Member

    Messages:
    2,732
    Likes Received:
    128
    Best Answers:
    1
    Trophy Points:
    300
    #2
    Okay... here it goes...

    Just login to your phpmyadmin see the table wp_users browse that... and you will see your admin login name and other details also you will see your encrypted password. Just replace it with the encrypted code i am writing below, it will reset your password to 123456 and then you can login to wp-admin and change it.

    Encrypted password to write:: e10adc3949ba59abbe56e057f20f883e

    this is the exact solution of your query...
     
    infogle, Jul 18, 2008 IP
    GAdsense likes this.
  3. GAdsense

    GAdsense Well-Known Member

    Messages:
    1,247
    Likes Received:
    60
    Best Answers:
    0
    Trophy Points:
    140
    #3
    I have seen the login names, there are two. One with my nick and other one is admin. But in the wp_pass .... I can't seem to see any encrypted or direct password.... Is there something wrong I am doing? ... thanks for the response.
     
    GAdsense, Jul 18, 2008 IP
  4. infogle

    infogle Prominent Member

    Messages:
    2,732
    Likes Received:
    128
    Best Answers:
    1
    Trophy Points:
    300
    #4
    contact me on yahoo you are going the wrong way i think... its a 15sec job...
     
    infogle, Jul 18, 2008 IP
  5. JSellnau_TSCC

    JSellnau_TSCC Peon

    Messages:
    166
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #5
    If there is no direct or encrypted password it could be blank ( as in the password is blank).... so just use the username and no password.
     
    JSellnau_TSCC, Jul 18, 2008 IP
  6. GAdsense

    GAdsense Well-Known Member

    Messages:
    1,247
    Likes Received:
    60
    Best Answers:
    0
    Trophy Points:
    140
    #6
    Thanks to Infogle, he helped me solve the problem via messenger. Repe'd you :)
     
    GAdsense, Jul 19, 2008 IP
  7. BANAGO

    BANAGO Active Member

    Messages:
    456
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    58
    #7
    Nice solution. How do you encrypt the password that way.?
     
    BANAGO, Jul 19, 2008 IP
  8. GAdsense

    GAdsense Well-Known Member

    Messages:
    1,247
    Likes Received:
    60
    Best Answers:
    0
    Trophy Points:
    140
    #8
    I guess he might have set that password and then opened the phpmyadmin to check out encrypted password and then gave me the same.... may be
     
    GAdsense, Jul 19, 2008 IP
  9. rohan_shenoy

    rohan_shenoy Active Member

    Messages:
    441
    Likes Received:
    20
    Best Answers:
    0
    Trophy Points:
    60
    #9
    That called 'hashing'. WP uses md5 hashing
    e10adc3949ba59abbe56e057f20f883e
    
<?php
$newpassword='123456';
echo md5($newpassword);//will output e10adc3949ba59abbe56e057f20f883e
?>
    PHP:
     
    rohan_shenoy, Jul 19, 2008 IP
  10. BANAGO

    BANAGO Active Member

    Messages:
    456
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    58
    #10
    Cool - Thanks!
     
    BANAGO, Jul 20, 2008 IP
  11. JamesDoe

    JamesDoe Peon

    Messages:
    16
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #11
    or just do it online http://www.phpbbhacks.com/md5.php :) I am aways forgetting my passwords and having to go in to SQL to reset them so much so I have a txt file with "5f4dcc3b5aa765d61d8327deb882cf99" thats the md5 string for "password"
     
    JamesDoe, Jul 20, 2008 IP
  12. rohan_shenoy

    rohan_shenoy Active Member

    Messages:
    441
    Likes Received:
    20
    Best Answers:
    0
    Trophy Points:
    60
    #12
    ^There is a simpler way:
    
UPDATE table_name SET password_field=MD5('your_password_string') WHERE username_field='your_username'
    Code (markup):
    Just run that SQL!
     
    rohan_shenoy, Jul 20, 2008 IP
  13. GAdsense

    GAdsense Well-Known Member

    Messages:
    1,247
    Likes Received:
    60
    Best Answers:
    0
    Trophy Points:
    140
    #13
    Thank you all, brilliant talented individuals ... that is why everyone loves DP :)
     
    GAdsense, Jul 21, 2008 IP
  14. stolpee

    stolpee Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #14

    Thanks a bunch for the info! Saved my day! :D:D
     
    stolpee, Oct 3, 2010 IP