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
0 Comments:
Post a Comment
Note: Only a member of this blog may post a comment.