Joomla! Discussion Forums

I've been attempting this over the past 2 hours with info found here and on G.

Here's what I came across basically which just isn't working me:

Q. How do I recover my admin password?

[i]A. You cannot recover the existing password, but you can reset it to a new password.
The passwords are stored using a one-way MD5 hash which prevents recovering the password.
But you can reset the password by editing the password field in the database.
Set the password to a known value and then you may log-in using that new password.

The password is stored in the MySQL database jos_users table password field. (change this for your table prefix if different)
Use a MySQL utility such as phpMyAdmin or MySQL Query Browser to edit this field.
Open the table, find your admin username, and then select that row for editing.
The password must be hashed, you cannot simply enter text into this field.

Set the password to a known value
- password = "this is the MD5 hashed password"[/i]

HASH - means along line of gobbkedeegook

------------------------------------------------------
- admin = 21232f297a57a5a743894a0e4a801fc3
- secret = 5ebe2294ecd0e0f08eab7690d2a6ee69
- OU812 = 7441de5382cf4fecbaa9a8c538e76783

I'm not seeing any of the above ?

Paste the hashed password into the field, - the password field obviously i'm guessing? - save the change, and log-in using the new password.

Just not working - Any ideas?

Note - my account was hacked recently which is why i'm using this method as can't login backend.

Installed on a web host or localhost?

In either case go the the jos_users table in the Joomla database and replace the existing password hash with the hash value listed in the second paragraph "Change the Password in the Database" http://docs.joomla.org/How_do_you_recov ... assword%3F once it has been replaced be sure to save the information. Change to another table then change back to make sure the new value stuck. The encrypted value is for the word secret. Once logged in again, change it to something else.

I have tried this on an install and it does work fine.

The other page you were reading was apparently for earlier versions of Joomla.

localhost..

The method in the link I provided will work for both local and remote (live) installs.

Phil - this is what i get:

Error

SQL query: Documentation

SELECT *
FROM `jos_users``password` d2064d358136996bd22421584a7cb33e : trd7TvKHx6dMeoMmBVxYmg0vuXEA4199
LIMIT 0 , 30

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':trd7TvKHx6dMeoMmBVxYmg0vuXEA4199

LIMIT 0, 30' at line 1

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

Should i go to "browse" or "structure" ?

http://docs.joomla.org/How_do_you_recov ... assword%3F ............. states i should go to "browse" - click on edit - a new window appears - tab password under "field"- then click go and paste d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199
as stated and the above errror comes up.

Any ideas?

thanks Phil - got it working in the end. All my articles "web written content" exists on SQL database but the articles no longer exist in the articles. Will I have to rebuild again?

No query involved in the password value change.

Go to phpMyadmin. find the table jos_users in the Joomla database and click on it

Then select the Browse Tab.

Then select the pencil icon in the row with the super_administrator (usually the first row) to edit the row. Look for password field in the edit screen and replace the encrypted password value with the following encrypted password value:
[code
d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199
[/code]

While you are editing the row, make sure the admin username is what it should be or make the change in that value also.

Scroll down some on the screen and make sure the dropdown box has the value Save in it and click GO to save the changed value.

This hash is for the word secret

Log in using your admin username and password secret

Thanks Phil - yes - got it sorted.

All my pages are missing though but content still exists in databse and pics still exist in public_html.

Is there a way of fixing it quick do you know?

cheers for help again btw...is this your full time job?

I don't have any quick ideas on why the content is not showing. If this is a local database try stopping and restarting apache and mysql from the servers control panel.

No, forum support is not my job, just a way to give back to the community. Right now my job is applying for jobs if you get what I mean.