How to Change Superadmin Password

The superadmin password is used in a content management system called Joomla. The admin's password is stored in the mySQL database that is used by the application. To change the password when unable to log in to the system, the administrator needs to access the mySQL database and change it in the table. This is done through the mySQL desktop console or your Web host server's browser interface.

Difficulty: Moderate

Instructions

1. Log in to your mySQL database. Most Web hosts have an application you use to access the mySQL database associated with your account. The application is called phpMyAdmin, and you can access it by logging into your Web host's control panel. This is the same area you use to upload files to your domain application.

2. Open the users table. The users table for Joomla has the format "<mydomain_users>." If your domain is "mysamplejoomla," then the table you want to access is "mysamplejoomla_users."

3. Scroll to the record that has the user type "Super Administrator." Because the administrator is created as the first user, this should be one of the first records in the table.

4. Execute the following code in the mySQL console: "update mysamplejoomla_users set password=MD5('myNewPassword')" where user type is "Super Administrator."
   Replace the "myNewPassword" with your own password.

5. Close the console and log in to your Joomla admin account with the new password.

References

• Joomlavm.com