« WordPress Trackback Tutorial
Joomla Templates »

Tutorial Joomla: Recover lost password in Joomla

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

Posted by admin on Tuesday, October 30th, 2007 at 4:09 pm.

20 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

Left by gail on November 6th, 2007

Thanks a lot. Worked!

Left by Johnson on April 16th, 2008

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!!

Left by rita on May 3rd, 2008

Thanks!

Joomla 1.5 installed, worked like a charm.

Left by Jurien on May 16th, 2008

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

Left by karen on June 11th, 2008

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!

Left by wineman on September 23rd, 2008

Thanks a mil! it worked

Left by Maingi on October 9th, 2008

THANK YOU!!! My site (Joomla 1.5.4) was hacked and this worked perfectly.

FYI - I upgraded my site to Joomla 1.5.8 immediately after the hack knowing it would overwrite info and restore the default config.

Left by Grateful on January 13th, 2009

Thanks — been worrying me when a client lost theres and I had reduced my own login to registered! most helpful

Left by blurtsmum on January 24th, 2009

Thanks!

Left by Fabro27 on March 9th, 2009

Thanks! I hope I can return the favor someday. joomlafool

Left by joomlafool on March 15th, 2009

Many thanks, Chris!

Left by Warren on June 24th, 2009

My bacon was saved to. LOL !

Thank you.

Left by Ana J on August 18th, 2009

Hi , You Are great, I am your fan, Thanks a lot

Left by Asif Hossain Shantu on October 26th, 2009

Unbelievable… a solution that ACTUALLY works!! I’m so happy right now, thanks for the quick solution, very easy to follow :-)

Left by BK on February 7th, 2010

hi

i did exactly the procedures in your tutorial and when i am trying to connect again the error is
Username and password do not match

please help me

Left by charalambos on March 23rd, 2010

help please

Left by charalambos on March 23rd, 2010

anyone help?

Left by charalambos on March 23rd, 2010

thanks…you da man!!!

Left by flebbs on April 14th, 2010

Thanks a lot. Really tried to get logged into the site with the passowrd I knew I set, but one of the other guys messed up. Didn’t really know if there was a way to solve this issue, apart from scrapping the lot. Thank God no one knew mySQL password. Thanks a lot

Left by Gerry80 on May 20th, 2010

Something to say?

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