• We are going to reset the "super administrator" password
  
• You must have access to your database.
• If you want to be safe, backup your database before making changes.
  
  

Finding the Password

• Log into your Joomla database.
• Click to edit the _users database (it will be preceded by "jos" or whatever was used at installation time)
• Edit the entry for where usertype = "Super Administrator" (it should be the first record)
  
  

Resetting the Password

In the password field there will be a string of characters. 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";

To be safe, only use alphanumeric characters, no... " - ! # " etc.

You have just reset your Joomla password! Go to your Joomla! domain at yourdomain.com/administrator and login with the new password. You should find you have logged in as a Super Administrator.