The Joomla! Forum ™



Forum rules


Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.



Post new topic Reply to topic  [ 14 posts ] 
Author Message
PostPosted: Mon Oct 31, 2005 7:32 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Oct 28, 2005 4:04 pm
Posts: 26
Hi Everybody,
I have forget my admin Password, and I cannot log into my Joomal Admin section. Please let me know how to solve the problem. The worse, I think I did is I open the Joomla database with phpMyAdmin(Also Installed on the system), and delete or modify the user (Admin), by the way password is encrypted so I cannot know what I set before. By the way, now I try to insert dummy name there, but when I open and log in Admin area it is saying Admin is not set.

Please let me know how to solve this problem.


Top
 Profile  
 
PostPosted: Mon Oct 31, 2005 7:59 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sun Oct 09, 2005 9:01 pm
Posts: 19
I think your best bet is to backup the database, and reinstall the CMS. Then create a new user with admin rights so that you have this user to login with after reloading your DB. Import your backup DB and login with the user you created then edit your admin account for the password you want and write it down and stick it in your safe  ;) Then you can delete the user you created if you would like or just remove the other admin account.

You could also set the password using phpmyadmin I'm sure but you have to give it the correct sytax to crypt the password. You should be able to find this on mysql's site.

There might be a better way but I'm just learning Joomla.

Regards,
Cordel


Last edited by cordel on Mon Oct 31, 2005 8:03 am, edited 1 time in total.

Top
 Profile  
 
PostPosted: Mon Oct 31, 2005 8:03 am 
User avatar
Joomla! Guru
Joomla! Guru

Joined: Tue Aug 23, 2005 9:45 am
Posts: 687
Location: La Grande, Oregon
If you changed the MySQL databasse and you are getting problems saying that the 'Admin is not set,' then you may need to reinstall, as suggested in this forum:  http://forum.joomla.org/index.php/topic,12443.0.html.

Before that, try going to the frontend and clicking on the 'Forgot Your Password," link.  If this is a Joomla install on your local server, that may not work.  You would have had to set up your SMTP settings or PHP mail settings too for this to work.  Good luck.

Charles

_________________
From the beginning...


Top
 Profile  
 
PostPosted: Mon Oct 31, 2005 8:03 am 
User avatar
Joomla! Guru
Joomla! Guru

Joined: Tue Aug 23, 2005 9:45 am
Posts: 687
Location: La Grande, Oregon
Dang, you beat me Cordel!

_________________
From the beginning...


Top
 Profile  
 
PostPosted: Mon Oct 31, 2005 9:03 am 
Joomla! Explorer
Joomla! Explorer

Joined: Fri Aug 19, 2005 2:09 pm
Posts: 306
Location: UK
Can you not doing something like updating the password row in phpmyadmin and inserting the name as an MD5 word?

_________________
Please visit our site for any Joomla! related hosting/design needs you may have. Also other IT Support including Web 2.0, Technology Reports, Email Hosting, Forum Hosting.

http://www.bitservices.co.uk


Top
 Profile  
 
PostPosted: Mon Oct 31, 2005 1:55 pm 
User avatar
Joomla! Champion
Joomla! Champion

Joined: Thu Aug 18, 2005 2:09 am
Posts: 5373
Location: California
FAQ: Recover Admin Password
http://forum.joomla.org/index.php/topic ... l#msg73707

_________________
██ AllMedia4Joomla Project
██ http://sourceforge.net/projects/allmedia4joomla/
██ AllMedia YöuTube Feed Gallery module released
██ Download: http://sourceforge.net/projects/allmedia4joomla/files/


Top
 Profile  
 
PostPosted: Mon Oct 31, 2005 1:58 pm 
User avatar
Joomla! Guru
Joomla! Guru

Joined: Tue Aug 23, 2005 9:45 am
Posts: 687
Location: La Grande, Oregon
Thanks Ken, that is great to know.  Now I don't have to misinform anymore...

_________________
From the beginning...


Top
 Profile  
 
PostPosted: Mon Oct 31, 2005 2:36 pm 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Fri Sep 02, 2005 3:14 pm
Posts: 237
Location: England
To change your new user into a Super Admin do the following.

First of all find what where your entry is in the jos_table. Change the gid to 25 and the usertype to Super Administrator. You then need to mess around with the jos_core_acl_aro table now. Insert a new row into this table, the user field is your user id from the jos_user table and the name field is your name from jos_user. After you have inserted the new data into the jos_core_acl_aro table make a note of your aro_id that has just been created.

Now head to the jos_core_acl_groups_aro_map and insert a new row. The group_id should be set to 25 and the aro_id should be set to your aro_id that was created when you inserted the row into the jos_core_acl_aro.

You have now created yourself a Super Admin acoount.


Top
 Profile  
 
PostPosted: Tue Nov 01, 2005 12:07 am 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Sun Aug 28, 2005 11:19 pm
Posts: 176
Location: Leeds, Yorkshire
It's easy to be wise after the event, but... have two SuperAdmin users!
I do... and I'm sure someone will now tell me why this is a Bad Idea  :D

Gary


Top
 Profile  
 
PostPosted: Tue Nov 01, 2005 5:50 am 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Sat Oct 08, 2005 3:25 pm
Posts: 363
Location: Australia
what is a super admin?
and why would you need to create one?

sorry if this sounds a little stupid, but this is the first time i've heard of a super admin for joomla.

_________________
http://www.persianari.com


Top
 Profile  
 
PostPosted: Tue Nov 01, 2005 6:33 am 
User avatar
Joomla! Guru
Joomla! Guru

Joined: Tue Aug 23, 2005 9:45 am
Posts: 687
Location: La Grande, Oregon
persianari wrote:
what is a super admin?
and why would you need to create one?

sorry if this sounds a little stupid, but this is the first time i've heard of a super admin for joomla.


I think he was just posting that to give you a way to get access to the backend if you lost your password.  If you create a super admin in the database, then you can get into the backend and have the rights to change the user password for your original administrator username.  Then you can delete the new super admin user once you are done and your access will be available again.  Just another way to gain access to the backend so you can fix the issue of a lost password

_________________
From the beginning...


Top
 Profile  
 
PostPosted: Tue Nov 01, 2005 7:00 am 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Sat Oct 08, 2005 3:25 pm
Posts: 363
Location: Australia
ohh. okay i get it now.
thanks.

_________________
http://www.persianari.com


Top
 Profile  
 
PostPosted: Tue Nov 01, 2005 12:41 pm 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Sun Aug 28, 2005 11:19 pm
Posts: 176
Location: Leeds, Yorkshire
charlwillia6 wrote:
persianari wrote:
what is a super admin?
and why would you need to create one?

sorry if this sounds a little stupid, but this is the first time i've heard of a super admin for joomla.


I think he was just posting that to give you a way to get access to the backend if you lost your password.  If you create a super admin in the database, then you can get into the backend and have the rights to change the user password for your original administrator username.  Then you can delete the new super admin user once you are done and your access will be available again.  Just another way to gain access to the backend so you can fix the issue of a lost password


Thanks! Must explain myself better in future... what I'd actually meant was that having two (or more) Super Administrators, for example Admin and yourself, means that if something happens to one account you can still use the other to do back-end Admin functions on your site. I always do this on my sites, so that I can log in as myself (when posting, for example), but still do all the admin functions (since I am the administrator of the site).

Gary


Last edited by Gary of Beeston on Tue Nov 01, 2005 12:45 pm, edited 1 time in total.

Top
 Profile  
 
PostPosted: Mon Sep 10, 2007 12:16 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat Jan 14, 2006 7:48 am
Posts: 5
I recently upgraded to release 1.0.13 and lost my password / access rights not just for myself as Super Admin, but also for the other two admin accounts. I have repeatedly reset my password but it keeps being reset to random values in the database. It's becoming really frustrating trying to access the site away from 'home'! Has anyone else experienced this?

I've also reset my passwords on the web host account just in case it's been hacked. I'm going to delete and recreate all the admin accounts from the back end to see if this resolves the problem, otherwise I shall be pulling out what little hair I have left!


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 14 posts ] 



Who is online

Users browsing this forum: No registered users and 12 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group