Goedkope merkkleding op www.kleren.com

Tutorial - How to recover Super Admin Password in Joomla

Discuss Joomla! and share tips here.

Moderator: Moderators Team

Tutorial - How to recover Super Admin Password in Joomla

Postby magnum on Sat Nov 01, 2008 8:38 am

Well many like me would have done beta testing on live site and suddenly find their backend Admin system get locked and hence unable to access Admin panel. So here I am going to explain what to do when such case arise

Joomla is so compact with phpmyadmin so even if admin panel gets locked you can reset most of the functions from PHPMYADMIN in cpanel.


Follow the steps to create a new Global Administrator through Phpmyadmin if your backend login access gets disabled or accidently deleted.

1]Log into your cpanel of your domain
2]Open Phpmyadmin
3]on the left side click joomla databse [generally will be yourdomain_j0151]
4]now on the right panel scroll down till you fins jos_users
5]click edit icon associated with jos_users table
6]Insert the following values

jos_users` VALUES
(62, 'Administrator2', 'admin2', 'your-email@email.com', '21232f297a57a5a743894a0e4a801fc3',
'Super Administrator', 0, 1, 25, '2005-09-28 00:00:00', '2005-09-28 00:00:00', '', '');
INSERT INTO `jos_core_acl_aro` VALUES (10,'users','62',0,'Administrator2',0);
INSERT INTO `jos_core_acl_groups_aro_map` VALUES (25,'',10);

7]Now press go at the bottom, a new super Admin with the name Administrator will be created.
8]now log in to your joomla admin panel with the following details
user name: Administrator2
p.w :admin2

9]Now change your password of any account including the current created inside your joomla backend admin panel.


Hope you all like it, any problem regarding joomla just dont hesitate to ask us.
Swamiyea Saranam Ayyappa -www.iyyappa.com I
#1 wrestling Portal I
My site
User avatar
magnum
Promoter
Promoter
 
Posts: 2134
Joined: Sat Oct 04, 2008 10:17 am
Online: 7h 16m 31s
DNBucks: 515
[Donate DNBucks]

Re: Tutorial - How to recover Super Admin Password in Joomla

Postby fareast on Sat Nov 01, 2008 11:50 am

Thanks for the tutorial...

its really help me to know how to recover a super admin password in joomla...
Unlimited Features Offers! http://www.webhostingpad.com/1975.html only $3.96/mo!
fareast
Member
Member
 
Posts: 415
Joined: Tue Sep 16, 2008 6:15 am
Online: 1h 15m 1s
DNBucks: 146
[Donate DNBucks]

Re: Tutorial - How to recover Super Admin Password in Joomla

Postby Zz15 on Sat Nov 01, 2008 6:01 pm

lol yup pass is in database most times. and i get headache trying to find those kinda things in the database. its really annoying :wink:
Zz15
Promoter
Promoter
 
Posts: 1379
Joined: Mon Dec 10, 2007 10:55 pm
Location: DNTEMPLE
Online: 3h 24m 5s
DNBucks: 217.2
[Donate DNBucks]

Re: Tutorial - How to recover Super Admin Password in Joomla

Postby magnum on Sun Nov 02, 2008 8:38 am

Zz15 wrote:lol yup pass is in database most times. and i get headache trying to find those kinda things in the database. its really annoying :wink:


its actually very simple,you find it difficult the first time you do, but once you get used to this you can make sure your site never collapse. I once had my successful site collapsed since I had no clue how to operate Phpmyadmin, now it wont happen again.
Swamiyea Saranam Ayyappa -www.iyyappa.com I
#1 wrestling Portal I
My site
User avatar
magnum
Promoter
Promoter
 
Posts: 2134
Joined: Sat Oct 04, 2008 10:17 am
Online: 7h 16m 31s
DNBucks: 515
[Donate DNBucks]

Re: Tutorial - How to recover Super Admin Password in Joomla

Postby xAcidx on Tue Nov 11, 2008 5:36 pm

XP before when i used Joomla I lost the password and I was despreate to find it
but I couldent. lol.

Anyways thanks for the share!
xAcidx
 

Re: Tutorial - How to recover Super Admin Password in Joomla

Postby cybermandu on Wed Nov 12, 2008 5:38 pm

thank you for sharing.
cybermandu
Member
Member
 
Posts: 365
Joined: Thu Jan 18, 2007 9:59 am
Online: 1h 24m 51s
DNBucks: 665
[Donate DNBucks]

Re: Tutorial - How to recover Super Admin Password in Joomla

Postby fareast on Mon Nov 17, 2008 9:54 am

thanks... :wink:
Unlimited Features Offers! http://www.webhostingpad.com/1975.html only $3.96/mo!
fareast
Member
Member
 
Posts: 415
Joined: Tue Sep 16, 2008 6:15 am
Online: 1h 15m 1s
DNBucks: 146
[Donate DNBucks]

Re: Tutorial - How to recover Super Admin Password in Joomla

Postby Kunkstar7 on Thu Nov 27, 2008 4:19 am

Very nice, I got locked out of my panel this morning....
Kunkstar7
Member
Member
 
Posts: 246
Joined: Sun Nov 09, 2008 2:11 am
Online: 0s
DNBucks: 35
[Donate DNBucks]

Re: Tutorial - How to recover Super Admin Password in Joomla

Postby Brothers on Wed Dec 03, 2008 9:02 am

wow.. its oweome magnum.. this like hack
Brothers
Advanced Member
Advanced Member
 
Posts: 977
Joined: Fri Aug 08, 2008 1:34 pm
Online: 3h 45m 3s
DNBucks: 804
[Donate DNBucks]

Re: Tutorial - How to recover Super Admin Password in Joomla

Postby magnum on Wed Dec 24, 2008 5:47 pm

Cheers guys, I had the same problem when I started with joomla it took me for a while to understand it, I will share more tips and tutorials on joomla in coming weeks.
Swamiyea Saranam Ayyappa -www.iyyappa.com I
#1 wrestling Portal I
My site
User avatar
magnum
Promoter
Promoter
 
Posts: 2134
Joined: Sat Oct 04, 2008 10:17 am
Online: 7h 16m 31s
DNBucks: 515
[Donate DNBucks]


Return to Joomla!

Who is online

Users browsing this forum: No registered users and 0 guests