Before we begin, you must have access to your database. If you don't, pass these instructions on to someone that does. It's also a good idea to backup your database before making changes, just in case something goes awry.
Finding the Password
- Log in to your Joomla database (via phpMyAdmin for example)
- Click to edit the _users database (will be preceded by your account name, for example: example_users
- Edit the entry for where usertype = "Super Administrator" (should be the first record)
Resetting the Password
In the password field you'll notice a string of characters. Joomla uses a one-way encoding method, which means you won't be able to retrieve your old password. However, you will be able to reset the password to a new one using mySQL's built in MD5 function:
UPDATE example_users SET password=MD5('yourpassword') WHERE usertype = "Super Administrator";
Voila - you just successfully reset your Joomla password 
Go to your joomla domain at example.com/administrator and try logging in with the new password. You should be logged in as Super Administrator.
Troubleshooting
If for some reason the above method does not work try encoding a password that contains only alphanumeric (a-z, 0-9) characters. This method may not work if your password contains special characters (@!#$).
Add this page to your favorite Social Bookmarking websites
| < Prev | Next > |
|---|
