Have you ever lost your Joomla password – how annoying is it! Well here’s a quick tutorial on how to reset your password.

Joomla uses one-way hash function (MD5) to set passwords so you cannot simply log into phpMyAdmin and get your password. You can however use phpMyAdmin to reset your password.

Log in to your phpMyAdmin account

Select your MySQL database from the left hand drop down menu

  1. Scroll down to jos_users and select the browse button
  2. Now click on the pencil next to your admin account, to edit the values
  3. Look down the function column and the row that contains the password information.
  4. Set the function column to MD5 from the drop down menu
  5. Now type in your required password in the field next to where you selected MD5
  6. Save your changes by clicking the GO button at the bottom of the page
  7. Login to your admin section of your website and check your new password has been setup correctly
Trackback This Post | Subscribe to the comments through RSS Feed

7 Responses to “Tutorial Joomla: Recover lost password in Joomla”

You saved my bacon !

thanks for a great site i use it all the time !

gail

Thanks a lot. Worked!

i did everything just as you said but it gives me back an error:sql query: mysql said: #1064 - you have an error in your sql syntax; check the manual that corresponds to your mysql server version for the right syntax to use near ‘A’ at line 1.

if somebody can help i would be very, very, very happy!!

Thanks!

Joomla 1.5 installed, worked like a charm.

THANK YOU…THANK YOU!
You saved the little sanity I had left!

WOW !!!!
It worked! I’m so thankful for your clear instructions here, as mysqladmin is totally uncharted territory for me. Worked great - Joomla 1.52

You saved me a weeks work!
Thanks!

Thanks a mil! it worked

Something to say?

Bad Behavior has blocked 507 access attempts in the last 7 days.