Add new user Super Admin WordPress
- SOLVED
I know is more a wordpress support here but maybe someone can help me with this to.
I have a joomla 2.5 website and i can't access enymore my /administrator
When i try to login i get this message: <em>You do not have access to the administrator section of this site.</em>
I need someone to go into my phpmyadmin and fix this problem, can create a new username or warever important is to be able to login again like super administator.
Ask me on private for login details
Or lets talk on skype : balanean.corneliu
Thank you.
Answers (3)
Firoja_Imtosupport answers:
Hi Balanean,
For the issue you can't login to system was, GID was not passed correctly in fnygt_users which is fixed now.
Balanean Corneliu comments:
Thank you. I will vote the prize, im sorry for Agus but i was waiting 3 hours for a solution without results.
zebra webdesigns answers:
Hello Balanean
Send me the login details, let me check it
Balanean Corneliu comments:
Agus added me first on skype if he can't solve the problem i will take the next one. Thank you.
Bob answers:
May be this can help you.
http://www.alphahost.lv/en/faq/joomla/joomla-admin-password-reset.html
Balanean Corneliu comments:
I was trying all this but is not working, i dont remember exactly why i have two table _users in that db because i have made that website 1 year ago.
The first one is fnygt_users and seems to be the active one.
And the second is the defaul jos_users but the users from theare are not working.
Balanean Corneliu comments:
The problem is in fnygt_users i dont have GID and i cant add the Super Admin permission without this group id. The GID need to be 25 to have full acces.
Bob comments:
Did you checked joomla docs?
http://docs.joomla.org/How_do_you_recover_or_reset_your_admin_password%3F
If you remember any other user's password then also you can access your joomla site as super admin.
Bob comments:
It has another method also of insert query which you can fire using phpmyadmin.
INSERT INTO `jos31_users`
(`name`, `username`, `password`, `params`)
VALUES ('Administrator2', 'admin2',
'd2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199', '');
INSERT INTO `jos31_user_usergroup_map` (`user_id`,`group_id`)
VALUES (LAST_INSERT_ID(),'8');