Reset Joomla administrator password?

Joomla's admin username can be easily changed with a simple MySQL query.  Open mysql console and execute the following query


UPDATE `jos_users` SET `password` = MD5( 'new_password' ) WHERE `jos_users`.`username` = "admin"