How to reset your Joomla administrator password

The Joomla administrator account is configured as part of the Joomla installation setup.  After you login, you can change your username, password and email address in the back-end user manager.

You can also add, edit and delete users and passwords from the User Manager.  Note that to do this you must be logged in as a member of the Super Administrator group.

However, in cases where you have forgotten your Joomla administrator password, this may not be possible. The Joomla administrator login page does not allow forgot password method for Administrators.

It’s always advisable to have more than one users as administrator, so that when one forget the password, the other user can login

However don’t worry, is still possible to change and recover the password.

The two methods below explains how

  • Direct Editing of Database
  • Log into cPanel and access phpMyAdmin(Please note some hosting companies use other CPanel alternatives like Plesk)
  • Click your joomla database name in the left menu
  • Click on the jos_users table in the left menu. If your tables have a prefix other than “jos”, find and click on the table that is similar to “_users”
  • Find the admin account you need to reset the password for and click the edit icon to the left of it to edit it.
  • Set the “password” field to “MD5”
  • Under “Value” type in your new password.
  • Click “Go”

Done!!

Id the editing of the password is not succesiful for one reson or another. You can add a new Super Administratoe to the database directly.

Add a New Super Administrator User in Database

  • Navigate to phpMyAdmin
  • Select the database for the Joomla! site in the left-hand drop-down list box. This will show the database tables on the left side of the screen.
  • Press the “SQL” button in the toolbar to run an SQL query on the selected database.
  • This will display a field called “Run SQL query/queries on database
  • Delete any text in this field and copy and paste the following query below
  • Press the Go button to execute the query and add the new Administrator user to the table.
  • Use the SQL query below to add another administrator account.

Waring: Before using the code below, note that:

  • Change the table prefix from jos_ to your own table prefix
  • The hashed password below is secret and is for public use in this blog. Change the password immediately after logging in to one of your own
  • INSERT INTO `jos_users`
  • (`name`, `username`, `password`, `params`, `registerDate`, `lastvisitDate`, `lastResetTime`)
  • VALUES (‘MyAdministrator’, ‘myadmin’,
  • ‘d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199’, ”, NOW(), NOW(), NOW());
  • INSERT INTO `jos_user_usergroup_map` (`user_id`,`group_id`)
  • VALUES (LAST_INSERT_ID(),’8′);

Leave a Reply

Your email address will not be published. Required fields are marked *