Need help?

Our experts have had an average response time of 13.14 minutes in February 2024 to fix urgent issues.

We will keep your servers stable, secure, and fast at all times for one fixed price.

3 ways to easily change Joomla admin password

by | Dec 27, 2016

Password protecting websites and software is vital to ensure that unauthorized users or hackers do not steal or mess up with the confidential data in your site, but only authorized users can access it.

But during certain scenarios such as security updates, account locks or hacks, losing or forgetting the password, etc., even the valid users may be unable to access their accounts with the available login credentials.

In such instances, password resets are inevitable for website software. If your website runs Joomla software, you can change the admin password in different ways, depending on the level of server access you have.

Today we’ll see how to change Joomla admin password from both the Admin dashboard and the database, with simple steps.

How to change Joomla admin password from the website backend

Joomla has an administrator user account, which can be used to manage the software and other user accounts in it. This admin user can manage Joomla and reset user account passwords from the Admin Dashboard.

To reset the password of user accounts, you can login to the Admin Dashboard as the administrator and update the details. As a security measure, it is advisable to periodically reset the user accounts passwords to stronger ones.

Also, if you know the current admin password, you can change that too from this website backend for Joomla, with these steps:

  1. Login to the back end of your Joomla website – http://domain.com/administrator – with the admin username and password.
  2. Under the Users Menu, select the Super User account.
  3. You can now ‘Edit Profile’ for admin user and change the login name, password and email address for this ‘admin’ account.
  4. Click Save & Close. You can now logout and login to the admin interface with the newly set password.

 

Change Joomla admin password

Change Joomla admin password

 

User passwords can also be reset with ‘Lost Password’ link in the Joomla site. But things may not be so easy all the time. There maybe cases when you forgot the admin password or the account gets hacked and you are unable to access it with the password.

It is not possible to change Joomla admin password with a ‘Lost Password‘ link, unlike other user accounts. In such cases, you need to manually reset it from the database.

[ You don’t have to lose your sleep to keep your customers happy. Our Hosting Support Specialists cover your servers and support your customers 24/7 at just $9.99/hour. ]

Here, we’ll see the steps to easily change Joomla admin password from the database.

How to change Joomla admin password from the database

In Joomla, a MySQL database is used to store data such as articles, menus, categories and users. To update the password in the Joomla database, first we have to identify the database name for the particular installation.

In the Joomla installation directory, locate the file “configuration.php“. This file defines Joomla settings and contains the details of the MySQL database for Joomla and its username and password.

 

change joomla admin password - config file

Joomla configuration file

 

Find the database name give for the entry “$db“.  Access the MySQL server from backend after connecting to the server via SSH. In the ‘mysql’ prompt, choose this database using the command:

mysql> use database-name

Verify the entry for the ‘admin’ user in the database table ‘*_users‘. It will display the id, username, password, email, etc. for the admin user.

mysql> select * from *_users where username='admin';

But the password displayed would be in MD5 format, which is an encrypted form. So we would have to reset the password to a new strong one.

To update the password for the admin user, use the update command:

mysql> update *_users set password=MD5("new-password") where username="admin";

 

Here is a snippet of the above steps to change Joomla admin password from the MySQL database:

 

Change Joomla admin password from database

Change Joomla admin password from database

 

This will change Joomla admin password to ‘new-password’ and you would now be able to login to the admin portal using this password.

If the Joomla admin user account itself got deleted, then it is possible to add a super user by inserting a new row into the users table.

[ Use your time to build your business. We’ll take care of your customers. Hire Our Hosting Support Specialists at $9.99/hr. ]

How to change Joomla admin password via PhpMyAdmin

Updating the password in the database can be done from the server backend or via the front-end interface at PhpMyAdmin for the website. Choose the Joomla database from the left panel in PhpMyAdmin.

It will list the database tables in the drop down. Click on the table for ‘users’. The entries in the users table will show in the right panel of the window.

Click on the ‘Edit’ button on the row corresponding to the ‘admin’ username in the table.

 

change joomla admin password via PhpMyAdmin

Edit admin user for Joomla in PhpMyAdmin

 

In the window that shows up, you would be able to change Joomla admin password. Choose ‘MD5’ encryption from the drop-down and enter the new password in the field.

 

Change Joomla admin password in database

Change Joomla admin password in database

 

Click on ‘Go’ on the bottom of the page and confirm that the password has been updated successfully:

 

change Joomla admin password - phpmyadmin

Verify the changes made for Joomla admin password

 

You can now successfully access your Joomla admin account with the new password that has been set.

In short..

Today we saw the different ways in which you can change Joomla admin password – from both front-end and back-end. It is also possible to change the super user by editing the ‘configuration.php’ file in Joomla root directory.

Before making any database or file changes, always keep a backup of the database so that it can be restored with minimal website downtime, in case something goes wrong.

The password we have given here is just for demo purposes. In your live website, always choose strong passwords to avoid risk of hacks.

If you’d like to know how to manage your Joomla websites with zero downtime, we’d be happy to talk to you.

 

STOP SPENDING TIME ON SUPPORT!

Do you spend all day answering technical support queries?

Wish you had more time to focus on your business? Let us help you.

We free up your time by taking care of your customers and servers. Our engineers monitor your servers 24/7, and support your customers over help desk, live chat and phone.

HIRE SUPPORT SPECIALISTS AT $9.99/HR

Bobcares provides Outsourced Web Hosting Support and Outsourced Server Management for online businesses. Our services include 24/7 server support, help desk support, live chat support and phone support.

0 Comments

Submit a Comment

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

Categories

Tags

Privacy Preference Center

Necessary

Necessary cookies help make a website usable by enabling basic functions like page navigation and access to secure areas of the website. The website cannot function properly without these cookies.

PHPSESSID - Preserves user session state across page requests.

gdpr[consent_types] - Used to store user consents.

gdpr[allowed_cookies] - Used to store user allowed cookies.

PHPSESSID, gdpr[consent_types], gdpr[allowed_cookies]
PHPSESSID
WHMCSpKDlPzh2chML

Statistics

Statistic cookies help website owners to understand how visitors interact with websites by collecting and reporting information anonymously.

_ga - Preserves user session state across page requests.

_gat - Used by Google Analytics to throttle request rate

_gid - Registers a unique ID that is used to generate statistical data on how you use the website.

smartlookCookie - Used to collect user device and location information of the site visitors to improve the websites User Experience.

_ga, _gat, _gid
_ga, _gat, _gid
smartlookCookie
_clck, _clsk, CLID, ANONCHK, MR, MUID, SM

Marketing

Marketing cookies are used to track visitors across websites. The intention is to display ads that are relevant and engaging for the individual user and thereby more valuable for publishers and third party advertisers.

IDE - Used by Google DoubleClick to register and report the website user's actions after viewing or clicking one of the advertiser's ads with the purpose of measuring the efficacy of an ad and to present targeted ads to the user.

test_cookie - Used to check if the user's browser supports cookies.

1P_JAR - Google cookie. These cookies are used to collect website statistics and track conversion rates.

NID - Registers a unique ID that identifies a returning user's device. The ID is used for serving ads that are most relevant to the user.

DV - Google ad personalisation

IDE, test_cookie, 1P_JAR, NID, DV, NID
IDE, test_cookie
1P_JAR, NID, DV
NID
hblid

Security

These are essential site cookies, used by the google reCAPTCHA. These cookies use an unique identifier to verify if a visitor is human or a bot.

SID, APISID, HSID, NID, PREF
SID, APISID, HSID, NID, PREF