Joomla Resources:

I have been using Joomla as a CMS for many of my clients websites as well as my own websites. Through the years I have found better ways of doing things as well as fixes to correct issues that have came up using Joomla. This blog post will be an ongoing process. I will continue to update this blog post as I gather more useful resources for Joomla. Feel free to bookmark this post or add it to your account so you can access it to check for updates.

Username/Password Force Reset

SQL Query to reset your Super Admin username and password to admin. Use this if for some reason you can not access your Super Admin account. You must have access to your host account to do this. I recommend backing up your database before applying this query.

UPDATE `jos_users` SET `name` = 'admin', `password` = 'af9083d4b82dbc0745b124db3b3cf15d:M0WuLowO4rtRTddG' WHERE `id` =62 LIMIT 1 ;

Unhack an extremely hacked Joomla Site

Resources mentioned in the video:

Mac: Firefox, Transmit, CyberDuck.
PC: Firefox, Filezilla, Putty SSH Client.


  • Michael E. Olsen
    September 18, 2009 at 12:21 am

    Hi Jerad,

    I have followed your nice guide but my sites a still messed up. Can you help me?


  • DKS
    December 31, 2009 at 11:46 am

    Jerad: I really like your site. I stumbled upon it as I was setting up a FB fan page and I really love your layout and content. Thanks!!

  • aldo
    August 1, 2011 at 7:56 am

    Hi Jerad, can you help me, My joomla was hack, now I try to fix it. When I open my website address, it appear normal, but when I search using google, hacked site appear.
    is there any database that I should change beside those in your video?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Get my Sunday Dispatch right in your inbox
Join 18.5K subscribers