Forgot Admin Password for Joomla 1.5

I have a lot of Joomla 1.5 websites that are still active and unfortunately I lost the password on one of them. I'm really bad in password management and if you share the same attitude as mine this easy hack will be of great benefit.

There are other ways I feel more comfortable with this method. This method requires that you still have the login to your server and given that you can still access your database.

Let's say your table prefix is still the default ( jos_ ) find the table jos_users or whatever prefix you used but ending in ( _users ) . See the SQL code below. On this table, replace the current value of your password with this one 'd2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199' then press 'Go' button to save.

SQL code for Joomla 1.5

INSERT INTO `jos_users`
   (`name`, `username`, `password`, `usertype`, `gid`, `params`)
VALUES ('Administrator', 'admin',
    'd2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199',
    'Super Administrator', 25, '');
INSERT INTO `jos_core_acl_aro`
VALUES (NULL, 'users', LAST_INSERT_ID(), 0, 'Administrator2', 0);
INSERT INTO `jos_core_acl_groups_aro_map`
VALUES (25, '', LAST_INSERT_ID());

d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199 is a code equivalent to "secret". So go to your website administrator login page again and sign in using

username: admin (given that this is the username like the table above)
password: secret

You should be able to login now.

Cheers!

Sources:
Joomla.org