Use the database to reset a password:

1. Go to phpMyAdmin. This is usually accessible through the control panel provided by your webhost. Contact your webhost if you cannot find the link to it.

2. Click on the database used for your Joomla site. (If you have more than one database and you do not know which one your Joomla site is using, you can find this on the Joomla Control Panel -> Global Configuration -> Server -> Database Settings.)

3. Scroll down to the users table. This is usually named 'jos_users' but your installation could be using a different prefix, e.g., 'j15_users'. The prefix is designated during the installation process.

4. Click on the Browse icon for the users table.

5. Find the row for the user whose password you wish to reset and click on the Edit icon for that row.

6. On the list of fields for the chosen row, find the 'password' field, and in the 'Function' column select 'MD5' from the dropdown.

7. In the text box on this row (to the right) type in the password you want to use.

8. Scroll down to the 'Go' button and click it.

9. The new password is now set.

separator

Watch the Video:

Permalink
Embed Code
Rating: 2.6 (356 Votes)
View Video
Category: Administration
Reset a user password using through the database user table

iPhone Video:

iphone

13 Comments Feed

  1. Nice tuto!!!
  2. Nice tutorial and instructions man.
    Thanx a lot.
    I changed my password in 10 secs.

    Thanx a lot.
  3. Thanks for your great article! It's what I am looking for these days.
  4. this article is useful to me!
  5. I recomand another windows password recovery tool windows password buster .it is powful.:-D
  6. I got very useful information from this article,thanks for sharing..
  7. very informative article
  8. thanks for sharing..
  9. I like this..
  10. very nice information...
  11. i followed the instructions but now i have this message on my website:

    Infinite loop detected in JError

    what have i done><img src=" />
  12. The "Infinite Loop" message in Joomla 1.7 can mean any kind of error. I doubt that it is related to resetting the password.
  13. Thanks very much. I'll check it later.

Add Comment


    • >:o
    • :-[
    • :'(
    • :-(
    • :-D
    • :-*
    • :-)
    • :P
    • :\
    • 8-)
    • ;-)

     

    Rate This:

    4459 Votes

    Share This:

    Save This:

    Sign in to save this to your Favorites.