Results 1 to 18 of 18
-
08-15-2008, 01:09 PM #1Junior Guru Wannabe
- Join Date
- Apr 2008
- Location
- India
- Posts
- 42
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
RegardsLast edited by P-nut; 08-17-2008 at 10:27 AM.
-
08-15-2008, 01:28 PM #2Disabled
- 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.
?>
-
08-15-2008, 01:34 PM #3WHT Addict
- Join Date
- Mar 2004
- Posts
- 142
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
-
08-15-2008, 01:42 PM #4Junior Guru Wannabe
- 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 InfotechLast edited by zapinfotech; 08-15-2008 at 01:46 PM.
-
08-15-2008, 01:45 PM #5Disabled
- 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.
-
08-15-2008, 01:45 PM #6WHT Addict
- Join Date
- Mar 2004
- Posts
- 142
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
-
08-15-2008, 02:13 PM #7Junior Guru Wannabe
- 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?
-
08-15-2008, 03:52 PM #8Retired Moderator
- Join Date
- Feb 2005
- Location
- Australia
- Posts
- 5,849
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
-
08-15-2008, 05:49 PM #9WHT Addict
- Join Date
- Mar 2004
- Posts
- 142
without knowing the encryption I can't help you.
Can you find the lines for loggin in? Then I might be able to helpMy Blog - My Web Hosting, Programming, Computing and Univeristy blog
-
08-15-2008, 06:35 PM #10Disabled
- Join Date
- Jul 2008
- Location
- Chillicothe Ohio
- Posts
- 20
-
08-15-2008, 08:17 PM #11Web Hosting Master
- 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...
-
08-17-2008, 06:24 AM #12Junior Guru Wannabe
- 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
-
08-20-2009, 07:57 AM #13New Member
- Join Date
- Aug 2009
- Posts
- 1
what password is that 6f16586689a09f5d64e9baa8a9768f16 and that 827ccb0eea8a706c4c34a16891f84e7b ?? need help. sorry form my english
-
08-20-2009, 09:36 AM #14Web Hosting Master
- Join Date
- Jan 2006
- Location
- India
- Posts
- 637
-
07-05-2011, 04:46 PM #15New Member
- Join Date
- Jul 2011
- Posts
- 2
can you decode this?
09CF2445BCBA8868923FD274F521E082B43DE1E5C7515394
-
07-05-2011, 06:30 PM #16WHT Addict
- Join Date
- Mar 2004
- Posts
- 142
What version of phpmyadmin ? does it have a salt ?
My Blog - My Web Hosting, Programming, Computing and Univeristy blog
-
07-05-2011, 10:16 PM #17New Member
- Join Date
- Jul 2011
- Posts
- 2
yes i think it has a salt
-
07-06-2011, 03:10 AM #18WHT Addict
- Join Date
- Mar 2004
- Posts
- 142
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