Joomla core

Query:

INSERT INTO `prefix_users`
   (`name`, `username`, `password`, `email`, `params`)
VALUES ('Simon Tech', 'teucg',
    MD5('CrazyHardAndLongPasswordwithNumbers131464'), 'tech@teucg.com', '');
INSERT INTO `prefix_user_usergroup_map` (`user_id`,`group_id`)
VALUES (LAST_INSERT_ID(),'8');

At this point, you should be able to log into the back end of Joomla! with the username and password . After logging in, go to the User Manager and change the password.

Manual input through PHPMyAdmin:

scroll down though its tables to locate jos_users table (you might have different prefix instead of jos_). Open it and click ‘Insert’ option on top:

howto-add-user-through-database.JPG

Next you should locate and open jos_user_usergroups_map table (you might have different prefix instead of jos_). Use ‘Insert’ option on top:

user_group_map_inphpmyadmin.JPG