Before you start

You can reset a Joomla administrator password in phpMyAdmin, but the steps depend on your Joomla version. Check your version first, because the method for older releases does not work on current ones.

If you still have access to your account's email address, try the "Forgot your Password?" link on the Joomla login form first. It sends a reset code to that address. The Login Module must be published on your site for this link to appear.

If you have SSH access and use Joomla 4 or later, you can also reset the password from the command line. SSH access is available on Web Hosting and WordPress Hosting plans, but not with root access.

Reset the password in phpMyAdmin

cPanel

  1. Log in to your client area at https://my.hostking.host and open your hosting control panel.
  2. Scroll to the Databases section and click phpMyAdmin.
  3. In the left-hand menu, click the Joomla database. If you are not sure which database Joomla uses, check the configuration.php file in your Joomla root folder.
  4. Find the users table. Its name is your table prefix followed by _users, for example abc_users. The prefix is shown as $dbprefix in configuration.php. Select the table with the same prefix as your other Joomla tables.
  5. Find the row for the administrator account you want to reset. Match it by username. The super user is not always the account you need.
  6. Click Edit for that row.
  7. Change the password value to a new password, using the method for your Joomla version (see the version notes below).
  8. Click Go to save the row.
  9. Open your site's login page and sign in with the new password.

DirectAdmin

The phpMyAdmin menu path in DirectAdmin is not covered here. Check DirectAdmin's own documentation for how to open phpMyAdmin, then follow the same steps as above.

Set the password for your Joomla version

Joomla 1.x to 3.1.x

In the password row, select MD5 in the function drop-down next to the field. Enter the new password in the value box, then save. Joomla stores these passwords as salted MD5 hashes.

Joomla 3.2.1 to 3.10 and Joomla 4 to 6

Do not use the MD5 method on these versions. Use the SSH command below, or use the "Forgot your Password?" link instead.

With SSH access, open a terminal in your Joomla root folder and run:

php cli/joomla.php user:reset-password --username="your-login"

Replace your-login with your Joomla username.

After you log in

Change the password again to one that only you know, using the password screen in Joomla's admin area. Joomla then stores it in its current format.

After an emergency reset, check that all super user accounts on the site are ones you recognise.

Troubleshooting

  • The password still does not work: check that you edited the row for the correct username and the correct users table prefix.
  • You cannot find the users table: confirm the database name and prefix in configuration.php.
  • You cannot reset the password: contact support using live chat on the website, or open a support ticket from your client area at https://my.hostking.host.
Was this answer helpful? 0 Users Found This Useful (0 Votes)