[FIXED] creating new user for joomla in phpmyadmin

Issue

I want to create a new user for joomla as Admin in phpmyadmin . How can I create it and grant all privileges to it?

Thanks in advance

Solution

You can adjust the values in phpmyadmin with the following query. Please adjust table prefix from jos_ to whatever yours is.

INSERT INTO `jos_users`
   (`name`, `username`, `password`, `params`, `registerDate`, `lastvisitDate`, `lastResetTime`)
VALUES ('Administrator2', 'admin2',
    'd2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199', '', NOW(), NOW(), NOW());

INSERT INTO `jos_user_usergroup_map` (`user_id`,`group_id`)
VALUES (LAST_INSERT_ID(),'8'); <br/>

At this point, you should be able to log into the back end of Joomla! with the username of "admin2" and password of "secret". After logging in, go to the User Manager and change the password to a new secure value and add a valid e-mail address to the account. https://docs.joomla.org/How_do_you_recover_or_reset_your_admin_password

Answered By - YellowWebMonkey