SimonTech DevelopmentSimonTech DevelopmentSimonTech

Development

  • +18585983494
  • tech@teucg.com

SimonTech DevelopmentSimonTech DevelopmentSimonTech

Development

  • Extensions
  • Contact
    • Resume
    • Portfolio
    • Clients
  • Support
    • Support Ticket
    • SaaS
    • Support Contracts
    • Knowledge Base
  • Login
    • Forgot Login?

Request Quote

Knowledge Base

Knowledge base
Joomla

Add admin via Database MYSQL

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

© 2008 - 2020 SimonTech Development
  • Extensions
  • Contact
    • Resume
    • Portfolio
    • Clients
  • Support
    • Support Ticket
    • SaaS
    • Support Contracts
    • Knowledge Base
  • Login