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 Del.icio.us 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: