This guide shows you how to reset a Joomla user password in the Loopia Customer Zone if it has been lost. The change is made directly in the MySQL database using the phpMyAdmin tool included in the Customer Zone.
Log in to the Customer Zone
Start by logging in to your Loopia Customer Zone at www.loopia.com/login.
A short way down the page you will find your databases listed under Databases. Click on the database that is linked to your Joomla site. If you do not yet have a database user, see our guide on creating a new MySQL database.
Open phpMyAdmin
Click Log in in the Admin row to open phpMyAdmin (the database management tool).
Log in using your database credentials. In the left-hand column, click the database name that matches your domain name.
Find the Joomla users table
You will now see a list of all the tables in the database. The table you are looking for is jos_users if you created your own Joomla installation. If you used the Loopia One Click Installer, it is usually called jos_your_domain__users.
Click that table and all Joomla users will be displayed. Click Edit next to the user whose password you want to change.
Set the new password
In the Password row, select the function MD5 and enter the new password you want to use in the Value field. Then click Go to save the change.
The user now has a new password and you should be able to log in to your Joomla installation.