How to Reset Your Lost Joomla Password in a few Easy Steps

Before we begin, you must have access to your database. If you don’t, pass these instructions on to someone that does. It’s also a good idea to backup your database before making changes, just in case something goes awry.
Finding the Password

Log in to your Joomla database (via phpMyAdmin for example)
Click to edit the _users database (will be preceded by your account name, for example: example_users)
Edit the entry for where usertype = “Super Administrator” (should be the first record)

Resetting the Password

In the password field you’ll notice a string of characters. Joomla uses a one-way encoding method, which means you won’t be able to retrieve your old password. However, you will be able to reset the password to a new one using mySQL’s built in MD5 function:

UPDATE example_users SET password=MD5(‘new password’) WHERE usertype = “Super Administrator”;

Voila – you just successfully reset your Joomla password Smiling Go to your joomla domain at example.com/administrator and try logging in with the new password. You should be logged in as Super Administrator.
Copying the Password from Another User

An alternate method to reset your password, if you’re not comfortable with SQL commands, is to simply copy and paste the password hash from another user (to which you know the password) over to your admin user. You’ll then be able to login as the admin user using that password. If you don’t have another user, you should be able to register as one, and then copy the password over.
Applying the Email From Another User

Yet another alternate method to retrieving your lost Joomla admin password is to change your admin user’s email address to one you are familiar with. Then use the lost password retrieval function (the “forgot password” link in the login section) to have your Joomla password emailed to you.

Change the Virtuemart product search minimum characters

To change the minimum characters you want to search for in your VirtueMart store edit the following file

administrator/components/com_virtuemart/classes/ps_main.php

Change around line 1273

if( $strlen > 2 ) {

to

if( $strlen > 1 ) {

for 2 character search

Speed up your Joomla! site

Here are a few tips for speeding up your Joomla! site.

Gzip, Sometimes

Encoding your pages with Gzip is an 90% solution…  If your server’s processor is faster than your bandwidth (again, 90% of the time), than enabling Gzip compression will actually speed up your site.  I say that because gzipping the pages does require some CPU horsepower.  Try enabling Gzip and see if your site loads any faster (especially on highly loaded servers).  If it doesn’t, or you get CPU warnings from your host, disable Gzip.  It can hurt you, but most of the time it does help.  The only way to find out is to try it.

Statistics May Seem Nice, but…

They use a ton of SQL queries to get done what they do.  They are not worth it at all!  If you want nice stats, use Google Analytics to track your users.  Stay away from 3pd stats components.  They do generate nice stats, but at a huge performance penalty.  The only statistic worth keeping is the search queries (from the Joomla config).  If you have access to the webserver, you can also disable logging statistics from the server end as well (this process is much more efficient, and only will really help if your server is heavily loaded).

SEF is not Server Friendly

One of the best things you can do to a site, is make the URL’s look more better.  The Joomla core does an acceptable job, but there are a handful of 3pd components that make really nice URLs.  The problem with these components, is that they are not very performance friendly (they use a ton of queries).  I prefer OpenSEF to any of the others (But it’s no longer actively developed) as it seems to be a good mix of power, flexibility and performance.  Keep in mind, that using SEF URLs is a tradeoff.  A good URL will look better to a search engine, and to end users, but it hurts the load time.  Think carefully before deciding to enable SEF URLs.  One thing you can do, is periodically optimize the database by purging unpublished and invalid URLs from the OpenSEF database (an option in the admin section of OpenSEF).

Enable Caching as Much as Possible

If you can, enable Joomla’s core content cache.  It does speed things up when viewing content and modules (mambots don’t need to be processed each time the page is loaded).  If you really want to speed things up for unregistered users, take a look at my  Page Caching component which caches entire pages.  This is probably the best performance gain you can find you unregistered users (the majority of users for 95% of websites).  This does not mean that you can forget about the rest of these optimizations, because the registered users will still see the uncached site.

For a complete list of Joomla Performance tips please visit: JoomlaPerformance.com

Activate SEO friendly URL in Joomla!

After a fresh install of Joomla your URL of a article may look something like this

http://www.hjdesign.nl/index.php?option=com_aicontactsafe&view=message&layout=message&pf=1&Itemid=58

This is of course not a very friendly URL to remember.
So lets change this to something more readable for everyone who visits your site.

  1. Rename htaccess.txt to .htaccess in your root folder of your Joomla installation
  2. Edit .htaccess and change # RewriteBase / to  RewriteBase / ( in short, remove the # )
  3. Login to your Joomla backend, and go to Global Configuration > Site
  4. On the left you will find the SEO settings.
  5. Change the setting of Search Engine Friendly URLs to Yes and click on Apply
    This will change the URL of the article to
    http://www.hjdesign.nl/index.php/contact
  6. To get rid of that ugly index.php change the setting of Use Apache mod_rewrite to Yes and click on Apply
    This will change the URL of the article to
    http://www.hjdesign.nl/contact
  7. If you want you can set the last option Add suffix to URLs to Yes.
    This will change the URL of the article to
    http://www.hjdesign.nl/contact.html
    The last one is just a matter of taste. Personally I leave this options disabled.

JError Unable to load Database Driver

After restoring a site with AkeebaBackup I got the following error.
JError Unable to load Database Driver

After some research the configuration.php missed the database information.
The following lines were not complete.

var $dbtype = ‘mysql’;
var $host = ‘xxxxxxxxxx’;
var $user = ‘xxxxxxxxxx’;
var $db = ‘xxxxxxxxx’;
var $dbprefix = ‘jos_’;

I filled those lines with my MySql info.

At the end of the configuration.php there is one more line that needs info.

var $password = ‘xxxxxxx’;

This is your database password. Non-encrypted.