Knowledgebase

How to reset your Joomla Password using PHPmyAdmin  Print this Article

Directions

Using phpMyAdmin built-in 'MD5' function for new passwords

1. Use a MySQL utility such as phpMyAdmin with MySQL 5.0.1 (or newer).

2. Open the correct database and select the table, jos_users . (Change default table prefix, 'jos_' to your table prefix if it is different.)

3. Select the record (or table row) for your administrator account (The first admin account, created by default, has an id of 62).

4. Click on 'Edit Record'.

5. To the right of the 'password' field, select the drop-down "function" of "MD5".

6. Enter new password in the 'data' field.

7. Save the record.

8. Point your browser to your site and log as the administrator using your new password.

9. Once logged in, Joomla will convert your md5 hash to a salted md5 hash, but you should change the password again to one that only you know.

Was this answer helpful?

Also Read

How to Use the Menu Manager in Joomla
The purpose of this tutorial is to teach you how to use the Menu Manager in Joomla. You should be...
How to Use the Trash Manager in Joomla
The purpose of this tutorial is to teach you how to use the trash manager in Joomla. You will...
Restoring a Akeeba JPA file on our servers
Note: Before proceeding ensure your website folder or has not got any joomla files in it...
Troubleshoot Database Connection Errors in Joomla 3.0
This article describes how to update database configuration settings in Joomla. You may need to...
How to Specify What Media Can be Uploaded in Joomla
This tutorial will teach you how to specify what media can be uploaded in Joomla. You will need...