Create a new "Super Administrator" user in joomla 1.5 using MySQL


	1) Go to the joomla database
		# e.g.	use myjoomla

	2) find a free ID - default admin ID is "62"

		SELECT id from jos_users;

	3) create a new user in table 'jos_users': 

		INSERT INTO jos_users (id,name,username,email,password,usertype,block,sendEmail,gid) values (100,'new admin','admin','123@example.com','531b5f50f082c59730b3bf7f9c457129:GA8lZqlJVZQbD8GYFGltJGNNIvjmcRcT','Super Administrator',0,1,25);
		
		# 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_core_acl_aro VALUES (100,'users','100',0,'Administrator',0);
		INSERT INTO jos_core_acl_groups_aro_map VALUES (25,'',100);

		# again, '100' is the free ID

	*) UNDO
		DELETE FROM jos_core_acl_groups_aro_map where aro_id=100;
		DELETE from jos_core_acl_aro where id=100;
		DELETE from jos_users where id=100;



by Markus Sesser