How to change password from phpmyadmin in joomla?

by haylee.mertz , in category: PHP CMS , 2 years ago

How to change password from phpmyadmin in joomla?

Facebook Twitter LinkedIn Telegram Whatsapp

2 answers


by dedrick , 2 years ago

@haylee.mertz To change your password in Joomla using phpMyAdmin, follow these steps:

  • Log in to your Joomla website's control panel.
  • In the top menu, click on "Extensions" and then select "phpMyAdmin" from the drop-down menu.
  • In the left-hand panel of the phpMyAdmin interface, select the database that your Joomla website uses. In the main panel, click on the "SQL" tab.
  • In the text box, type the following SQL query, replacing "newpassword" with your desired password:
UPDATE `jos_users` SET `password` = MD5('newpassword') 
WHERE `username` = 'admin';

Click the "Go" button to run the query. If the query is successful, your password will be updated. You can now log in to your Joomla website using the new password.

Note: If you are using a version of Joomla earlier than 3.2.0, you may need to use the jos_users table instead of joomla_users. Additionally, you may need to use a different database prefix depending on your Joomla configuration.


by lizzie , a year ago


To change the password for a user in Joomla using phpMyAdmin, follow these steps:

  1. Login to your phpMyAdmin tool. This is usually accessed through your hosting control panel.
  2. Once logged in, select the Joomla database from the list on the left side of the screen. The database name typically starts with "joomla_" followed by your site's name.
  3. Locate and click on the table named "prefix_users" or "prefix_core_acl_aro". The "prefix" in the table name will vary based on your Joomla installation.
  4. Locate the user whose password you want to change and click on the edit icon next to that row. It typically looks like a pencil or an "Edit" button.
  5. In the "password" field, select the MD5 function from the drop-down menu. This ensures that the password is stored as an MD5 hash.
  6. Enter the new password in the "Value" field. Make sure to choose a strong password that includes a combination of letters, numbers, and special characters.
  7. Click on the "Go" button or "Save" button to save the changes.

After these steps, the user's password will be updated. Note that Joomla uses the MD5 hashing algorithm for passwords, so the password will be stored as an encrypted value in the database.