Lost Joomla admin password

This post is also available in: Slovenian

Have you ever try to access to certain web page build in joomla, but of course forget the password, username or email?

If there’s a login module on website, then click on forgoten password/username will reset password, but um, if the website doesn’t have it, then there’s a problem. Or, oh, you can not longer accessed the used email address.

In the MySQL databese under jos-users you can see all usernames that are used on the website. Passwords are encrypted so they can not be directly reapired, but can be reset.

There are many solutions for that problem, but they only work, if you can managed the MySQL database. In Joomla database found jos_users and do one of the solutions offered below:

  • copy the password from another user
    if we know other user’s password, copy its encrpyted password and past it under the super admin user
  • change email address
    use another user’s email address (for who you know password) for admin user
  • use the SQL command
    UPDATE jos_users SET password = MD5( ‘new password‘ ) WHERE jos_users.username = “admin“;

Thus, the password has been changed and re-log in joomla site and editing.


Works as system engineer in Slovenian Enterprise in Microsoft environment focusing on security, deployments, SharePoint, SCCM and CheckPoint firewall. Author of successful blog about IT security, Microsoft tips & tricks, social media, internet trends.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.