Create joomla 1.5 admin

This is something I do often enough to not want to google it ..

Step 1
Create the new Joomla! User

REPLACE INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`, `activation`, `params`) VALUES (’60’, ‘Admin2’, ‘admin2’, ‘user@usersemailaddress’, ‘21232f297a57a5a743894a0e4a801fc3:abcdefghijklmnopqrstuvwxyz012345’, ‘Super Administrator’, ‘0’, ‘0’, ’25’, ‘2000-01-01 00:00:00’, ‘0000-00-00 00:00:00’, ”, ”);
The code above creates a new user with ID number 60 and the name set to admin2.
The password here needs to be changed to an MD5 hash that you know Make an MD% hash here http://www.miraclesalad.com/webtools/md5.php

Step 2
Create an ARO object out of the new Joomla! user

REPLACE INTO `jos_core_acl_aro` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES (‘8’, ‘users’, ’60’, ‘0’, ‘Admin2’, ‘0’);
This creates an ARO object with ID number 8. Note that the ‘name’ field must match the ‘name’ field in Step 1

Step 3
Next you will need to map this ARO object to the Super Administrator group, which by default is group ID 25:

REPLACE INTO `jos_core_acl_groups_aro_map` (`group_id`, `section_value`, `aro_id`) VALUES (’25’, ”, ‘8’);

Thanks ProjectAmplify