Here are couple simple to follow steps on how to reset a Joomla password from a Linux terminal. This guide assumes that you have an access to your mysql database via Linux terminal.

First choose your new password. For example let's use "joomla-password-reset" as a new password. Generate md5-hash from your new password:

$ echo -n "joomla-password-reset" | md5sum
7263e3513f08b709f55626bcc6d75ac7

Have your md5 hash password ready and login to your database:

$ mysql -p -u username

In the next step select your joomla database.

mysql> use joomla_database_name;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql>

The default ID of an admin user is 62. Unless you have not done anything to change it this is your admin user too. Execute a following mysql command to reset your joomla password to "joomla-password-reset" password:

mysql> update jos_users set password='7263e3513f08b709f55626bcc6d75ac7' where id='62';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> 

All done. Now navigate your browser to your admin page and enter new password: joomla-password-reset



Free Linux eBooks

Do you have the right skills?

Our IT Skills Watch page reflects an up to date IT skills demand leaning towards the Linux and Unix environment. We have considered a number of skills and operating systems.

See the result...

Linux Online Training

Learn to run Linux servers and prepare for LPI certification with Linux Academy. 104 available video lessons with PDF course notes with your own server!

Go to top