Create a new "Super Administrator" user in joomla 2.5 using MySQL
1) Go to the joomla database
# e.g. use myjoomla
2) find a free ID - default admin ID is "42"
SELECT id from jos_users;
3) create a new user in table 'jos_users':
INSERT INTO jos_users values (100,' newadmin','newadmin','123@example.com','531b5f50f082c59730b3bf7f9c457129:GA8lZqlJVZQbD8GYFGltJGNNIvjmcRcT','Super Administrator',0,1,'','',1,'');
# ID=100 --> a free ID
# 531b5f50f082c59730b3bf7f9c457129:GA8lZqlJVZQbD8GYFGltJGNNIvjmcRcT is the salted hash for the secure password '123' ;)
# feel free to change the password afterwards by WebGUI!
4)
INSERT INTO jos_user_usergroup_map values (100,8);
# again, '100' is the free ID
# '8' is the value for Super Admins
*) UNDO
DELETE FROM jos_user_usergroup_map where aro_id=100;
DELETE FROM jos_users where id=100;
by Markus Sesser