Reset Joomla User password

To reset the Joomla administrator password, you can do it with with a simple MySQL query.

1. Login to your Joomla Mysql database from phpmyadmin
2. Select Joomla’s database from the drop-down menu on the left
3. Open the SQL tab
4. In the text field write the following SQL query:
UPDATE jos_users SET password = MD5( ‘new_password’ ) WHERE username = ‘admin’;

 

Note:     "new_password" – replace this with the new password you wish to use.
            "admin" – replace this if your admin username is different.

Once you are ready, click on the GO button to submit the query. If everything goes fine without errors, you should be able to login to Joomla with the new password. You can also reset other users password using this query instead of the "admin".

Share

- has written 121 posts.


Leave a Reply

You must be logged in to post a comment.