How do I recover & replace password through SQL database? - Joomla! Forum - community, help and support
i've been attempting on past 2 hours info found here , on g.
here's came across isn't working me:
q. how recover admin password?
[i]a. cannot recover existing password, can reset new password.
the passwords stored using one-way md5 hash prevents recovering password.
but can reset password editing password field in database.
set password known value , may log-in using new password.
the password stored in mysql database jos_users table password field. (change table prefix if different)
use mysql utility such phpmyadmin or mysql query browser edit field.
open table, find admin username, , select row editing.
the password must hashed, cannot enter text field.
set password known value
- password = "this md5 hashed password"[/i]
hash - means along line of gobbkedeegook
------------------------------------------------------
- admin = 21232f297a57a5a743894a0e4a801fc3
- secret = 5ebe2294ecd0e0f08eab7690d2a6ee69
- ou812 = 7441de5382cf4fecbaa9a8c538e76783
i'm not seeing of above ?
paste hashed password field, - the password field i'm guessing? - save change, , log-in using new password.
just not working - ideas?
note - account hacked why i'm using method can't login backend.
here's came across isn't working me:
q. how recover admin password?
[i]a. cannot recover existing password, can reset new password.
the passwords stored using one-way md5 hash prevents recovering password.
but can reset password editing password field in database.
set password known value , may log-in using new password.
the password stored in mysql database jos_users table password field. (change table prefix if different)
use mysql utility such phpmyadmin or mysql query browser edit field.
open table, find admin username, , select row editing.
the password must hashed, cannot enter text field.
set password known value
- password = "this md5 hashed password"[/i]
hash - means along line of gobbkedeegook
------------------------------------------------------
- admin = 21232f297a57a5a743894a0e4a801fc3
- secret = 5ebe2294ecd0e0f08eab7690d2a6ee69
- ou812 = 7441de5382cf4fecbaa9a8c538e76783
i'm not seeing of above ?
paste hashed password field, - the password field i'm guessing? - save change, , log-in using new password.
just not working - ideas?
note - account hacked why i'm using method can't login backend.
installed on web host or localhost?
Comments
Post a Comment