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

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";

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 (@!#$).