Page 1 of 1

Lost Admin password

Posted: Tue May 15, 2012 6:39 pm
by SownDesign
I am new to Joomla and am unable to log in to admin site. I think I have forgotten my username or password. I have attempted to search the forum and the Quickstart Guide but the couple of posts that have a similar problem doesn't show a resolution and the login screen in the book is different than the login admin screen I see.How do I find my username and password?

Re: Lost Admin password

Posted: Tue May 15, 2012 7:22 pm
by numinousmedia
Are you the Super User for your website? Also, do you have access to your MySQL Database?

Re: Lost Admin password

Posted: Tue May 15, 2012 11:51 pm
by Sean Clement
Login to your PHPMyAdmin database and look for the '#_users' (# = your table prefix) within the left hand menu.

In there you will be able to find what your username is (if you are the only registered account, if not, look for your email address). Then try logging in via the 'administrator' area of your site with a list of common passwords that you use.

If that doesn't work;
Click the 'Edit' link and insert the below text into the 'password' field.

Code: Select all

d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199
After you have inserted the above code into the 'password' field click the 'Go' / 'Save' button at the bottom of the screen.

Your new password will be 'secret' (without single quotes).

Login and change the password immediately to something that you will remember.

Re: Lost Admin password

Posted: Sun Aug 11, 2013 11:20 pm
by flashpointmm
I tried this and while I can now log in with the password 'secret', I can't access the User Manager to change my password. I keep getting this error message...

Joomla!
500 - An error has occurred.

Table 'flash_dbjoomla.bhkj6_user_notes' doesn't exist SQL=SELECT n.user_id, COUNT(n.id) As note_count FROM bhkj6_user_notes AS n WHERE n.user_id IN (42) AND n.state >= 0 GROUP BY n.user_id

Return to Control Panel

Re: Lost Admin password

Posted: Fri Aug 16, 2013 3:11 am
by flashpointmm
Don't worry, I've fixed the issue... Extension Manager>Database>Fix