Results 1 to 18 of 18
  1. #1
    Join Date
    Apr 2008
    Location
    India
    Posts
    42

    Arrow How to get website admin user & password by phpmyadmin?

    Hi,

    I have lost my user id and password, but my site is running and I have its ftp access as well as phpmyadmin for database (mysql).

    Can anyone guide me how can I know my admin user id & password?

    In phpmyadmin there are these tables-
    ----------------------------
    * Browse web_banner
    * Browse web_cat
    * Browse web_config
    * Browse web_country
    * Browse web_list
    * Browse web_user
    * Browse web_user_temp
    ----------------------------

    Thanks
    Regards
    Last edited by P-nut; 08-17-2008 at 10:27 AM.
    ZAP INFOTECH
    Ph: 91-11-64627774,
    www.zapinfotech.com
    Email : info [@] zapinfotech.com

  2. #2
    Join Date
    Jul 2008
    Location
    Chillicothe Ohio
    Posts
    20
    Good chance that it's the first user in web_user. Although, again, chances are it's encrypted so that people who are in phpMyAdmin cannot see the 'real' password. Although if you know for a fact that the password is setup with md5(); you can recreate the password by doing.

    PHP Code:
    <?php 
    $before_md5 
    'password'
    $after_md5 md5($before_md5);
    echo 
    $after_md5// Presents u with the new hashed pass.
    ?>

  3. #3
    I would say your username would be in web_user and possibly the password but the password may be encrypted. If so then unfortunatly you won't be able to recover your original password.
    My Blog - My Web Hosting, Programming, Computing and Univeristy blog

  4. #4
    Join Date
    Apr 2008
    Location
    India
    Posts
    42
    I found the admin detail in this table:

    web_config-

    -----------------------------
    site_title : varchar(100) :

    site_url : varchar(100): http://mysite.com/web/

    site_email : varchar(100): info@mysite.com

    site_pass : varchar(100) : 21232f297a57a5a743894a0e4a801fc3

    site_theme : varchar(100) : testing

    site_ip : varchar(100) : 127.0.0.1

    ---------------------------------------------

    I tried to change this encoded password as well as to use forget password option, but did not get success. Its not recognizing email and not accepting password.

    Thanks
    Zap Infotech
    Last edited by zapinfotech; 08-15-2008 at 01:46 PM.
    ZAP INFOTECH
    Ph: 91-11-64627774,
    www.zapinfotech.com
    Email : info [@] zapinfotech.com

  5. #5
    Join Date
    Jul 2008
    Location
    Chillicothe Ohio
    Posts
    20
    You should look into the login system, and see how they compare the password, and then hook into it and recreate a new pass.

  6. #6
    The best way in my opinion then is to hire a programmer to dig through the code. Find out what is used to encrypt the password and then encrypt a new password for you.

    Usually I would suggest adding a new account and then changing admin rights onto the new account but u can't do this in your situation I don't believe.

    Edit: As a note, this wouldn't require much, expect to pay for an hour max (it won't take an hour but people generally bill by the hour)
    Last edited by volmasoft; 08-15-2008 at 01:46 PM. Reason: To add more rather than double posting.
    My Blog - My Web Hosting, Programming, Computing and Univeristy blog

  7. #7
    Join Date
    Apr 2008
    Location
    India
    Posts
    42
    that an good idea to take support for a php programmer

    how can decode this lengthy password - 21232f297a57a5a743894a0e4a801fc3

    Is there any way?
    ZAP INFOTECH
    Ph: 91-11-64627774,
    www.zapinfotech.com
    Email : info [@] zapinfotech.com

  8. #8
    Join Date
    Feb 2005
    Location
    Australia
    Posts
    5,849
    Quote Originally Posted by zapinfotech View Post
    how can decode this lengthy password - 21232f297a57a5a743894a0e4a801fc3
    That password is "admin". Wow, does that make me a l33t h4x0r?

    Edit: or just someone who can use Google...
    Last edited by foobic; 08-15-2008 at 03:57 PM.
    Chris

    "Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them." - Laurence J. Peter

  9. #9
    without knowing the encryption I can't help you.

    Can you find the lines for loggin in? Then I might be able to help
    My Blog - My Web Hosting, Programming, Computing and Univeristy blog

  10. #10
    Join Date
    Jul 2008
    Location
    Chillicothe Ohio
    Posts
    20
    Quote Originally Posted by foobic View Post
    That password is "admin". Wow, does that make me a l33t h4x0r?

    Edit: or just someone who can use Google...

    Definitely the second option. :p

    Quote Originally Posted by Some Google Link
    this is a mod of one of the previous queries posted in here. the basic thing is, to add this: 21232f297a57a5a743894a0e4a801fc3 to your query, that oryginally results in a username lists with a MD5 encrypted password. this one finds mysql dumps with for a users who's passwords are "admin" the "21232f297a57a5a743894a0e4a801fc3" is md5 result for "admin" you can try it with other queris on this site. use also: 63a9f0ea7bb98050796b649e85481845 for root 098f6bcd4621d373cade4e832627b4f6 for test 3c3662bcb661d6de679c636744c66b62 for sex f561aaf6ef0bf14d4208bb46a4ccb3ad for xxx if you'll get lucky, you'll get a username, and a encryoted password, witch is the one above that u used. remember, that this works for all files that contain plaintex username and md5 encrypted passwords. use this techniq with other queris that you'll find here uff... i hope i made my self clear.

  11. #11
    Join Date
    Feb 2003
    Location
    AR
    Posts
    2,382
    OT, but I always try md5decrypter.com when trying to figure out a lost password before resetting for a client...

  12. #12
    Join Date
    Apr 2008
    Location
    India
    Posts
    42
    Thanks Buddies to support me

    I got my password afterall, I just create a new user & got the encoded password from phpmyadmin & applied it to admin password.

    Its working fine now....

    Thanks once again buddies
    ZAP INFOTECH
    Ph: 91-11-64627774,
    www.zapinfotech.com
    Email : info [@] zapinfotech.com

  13. #13
    what password is that 6f16586689a09f5d64e9baa8a9768f16 and that 827ccb0eea8a706c4c34a16891f84e7b ?? need help. sorry form my english

  14. #14
    Join Date
    Jan 2006
    Location
    India
    Posts
    637
    for 827ccb0eea8a706c4c34a16891f84e7b - it seems to be : 12345
    ►ExpertWebHost.NET- Instant reliable hosting since 2008+
    ►Quality Shared, Reseller, SEO and VPS hosting
    ►Choose to host from US/Uk/Canada/Singapore/Netherlands/Australia - 10 locations

  15. #15
    can you decode this?

    09CF2445BCBA8868923FD274F521E082B43DE1E5C7515394

  16. #16
    What version of phpmyadmin ? does it have a salt ?
    My Blog - My Web Hosting, Programming, Computing and Univeristy blog

  17. #17
    yes i think it has a salt

  18. #18
    Okay then without knowing the salt and generating a new set of rainbow tables it's not possible.
    My Blog - My Web Hosting, Programming, Computing and Univeristy blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •