Usually, you can add, edit and delete users and passwords from the back-end User Manager. To do this, you must be logged in as a member of the Super Administrator group. In certain situations, this may not be possible. For example, your site may have been “hacked” and had the passwords or users changed. Or perhaps the person who knew the passwords is no longer available. Or maybe you have forgotten the password that was used.

In these cases, it is still possible to fix the problem in the Joomla database so you can log back in as a Super Administrator.

Change the Password in the Database

If the admin user is still defined, the simplest option is to change the password in the database to a known value. This requires that you have access to the MySQL database using phpMyAdmin or another client.

  1. Navigate to phpMyAdmin and select the database for the Joomla site in the left-hand side drop-down list box. This will show the database tables on the left side of the screen.
  2. Click on the table “jos_users” in the list of tables (note: you may have a prefix that is not jos_, simply go to the _users table for your prefix).
  3. Click on the “Browse” button in the top toolbar. This will show all of the users that are set up for this site.
  4. Find the user whose password you want to change and press the Edit icon for this row.
  5. A form will display that allows you to edit the password field. Copy the value

d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199

Into the password field and press the Go button. phpMyAdmin should display the message “Affected rows: 1”. At this point, the password should be changed to “secret”.

Log in with this user and password and change the password of this user to a secure value. Check all of the users using the User Manager to make sure they are legitimate. If you have been hacked, you may want to change all of the passwords on the site.

Happy Clients

  • I have been pleased to work with PixelKiosk on several projects involving informational sites on WordPress and E-Commerce sites on both Volusion and Magento. They have demonstrated expertise in both technology and design and appreciates the importance of fine details to satisfy the experience of the online customers.

    ROY FONG, IMPERIALTEA.COM, USA.
  • I have been working with PixelKiosk for over three years and have always found projects to be processed efficiently and to a very high standard. In addition I have very much enjoyed getting to know my Account Manager (Atish) on a more personal level, he is a likeable character with a great sense of humour!

    MATT PESKETT, FIRETOP LTD, UK
  • PixelKiosk has twice redesigned our Historical Remedies website, and continues to service and revise the site for us as needed. PixelKiosk is able to quickly translate our vision into a design that supersedes our expectations. PixelKiosk is well versed in a range of web platforms, and knows how to best guide his clients to what suits their needs.

    ROBERT COHANIM, HISTORICALREMEDIES.COM, USA.
  • PixelKiosk always delivers a great product for a great price. They always strive to make sure we are 100% satisfied with the final product. I would highly recommend the Pixelkiosk team!

    ADAM MURPHY, USA.