forgot admin password

All about webserver configurations, PHP and databases.

Moderator: Thorsten

Post Reply
drops
Posts: 8
Joined: Tue Oct 05, 2010 6:44 pm

forgot admin password

Post by drops »

Hi,
Its stupid but I forgot admin password :oops: . phpMyFaq Ver 2.6.15.
There is no other user created.
I have phpmyadmin installed, is there any way to edit user password in faquser table?
Solution from this topic not working:
viewtopic.php?f=6&t=812
UPDATE
faquser
SET
pass = MD5('password')
WHERE
id = 1
jason102178
Posts: 200
Joined: Tue Nov 02, 2010 9:08 am
Location: United States-Ohio
Contact:

Re: forgot admin password

Post by jason102178 »

Have you tried forgot password feature?


Cheers,

Jason
phpMyFAQ Quality Assurance / Forum Moderator
Amazon.com Wishlist
jason102178
Posts: 200
Joined: Tue Nov 02, 2010 9:08 am
Location: United States-Ohio
Contact:

Re: forgot admin password

Post by jason102178 »

But if you want to use phpmyadmin ill show you how to...

First login to phpmyadmin you will see a screen like below, click on Database
database.JPG
then the next screen you will have 2 options click on the first one which will be your database
database1.JPG

Then the 3rd screen you have to select faquser
faq user.JPG

4th screen select the user Admin by clicking on the left side the thing that looks like a pencil
admin1.JPG
Then the last one t will show your user name "Admin " and below that will be your password, it will be a bunch of numbers since its encrypted, all you do is remove whatever is in the password field and enter a new password then click on go...
You do not have the required permissions to view the files attached to this post.
phpMyFAQ Quality Assurance / Forum Moderator
Amazon.com Wishlist
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: forgot admin password

Post by Thorsten »

Hi,

please note that you have to encrypt the password by using MD5()

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
jason102178
Posts: 200
Joined: Tue Nov 02, 2010 9:08 am
Location: United States-Ohio
Contact:

Re: forgot admin password

Post by jason102178 »

Thanks for reminding me i forgot to include to select MD5 so to do this you will be at the screen that you change your password and beside it, it will say session id , use the drop down menu and select MD5 then press go
session id.JPG
You do not have the required permissions to view the files attached to this post.
phpMyFAQ Quality Assurance / Forum Moderator
Amazon.com Wishlist
drops
Posts: 8
Joined: Tue Oct 05, 2010 6:44 pm

Re: forgot admin password

Post by drops »

Thanks for help. This how to is just.... wow.... perfect :!:

Forgot password feature aint working, i think its not configured since im not the person who did the instalation and config.

I think i did everythnig good, i got this green message from my phpmyadmin:
Modified records: 1
UPDATE `faq`.`faquser` SET `session_id` = MD5( 'password' ) WHERE `faquser`.`user_id` =1;

but when i try to login to myfaq im getting:
User or password not valid.
jason102178
Posts: 200
Joined: Tue Nov 02, 2010 9:08 am
Location: United States-Ohio
Contact:

Re: forgot admin password

Post by jason102178 »

so did you create your own password where it showed the old encrypted password for example the old encrypted password was something like $4358393dhsk$ then change that to somthing for example changed it to testpasssword then select MD5 for session ID then go because this should work unless something is wrong with your installation. besure to make sure admin is lower case when you try to enter in username...

Also if you select forgot password type in admin for username then email address if the email address you entered does not match the admin accoun it will inform you that you have entered in the wrong username or email but if you type in the correct email then it will say email has been sent and it will send a temp password....
phpMyFAQ Quality Assurance / Forum Moderator
Amazon.com Wishlist
drops
Posts: 8
Joined: Tue Oct 05, 2010 6:44 pm

Re: forgot admin password

Post by drops »

Did every thing just like you wrote.

Forgot password feature say "E-Mail was sent." but i'm not receving this mail (SPAM checked).
drops
Posts: 8
Joined: Tue Oct 05, 2010 6:44 pm

Re: forgot admin password

Post by drops »

OK. This is stupid. New installation will be faster. Which tables must I ekspotr to sql file and then import after new installation to keep all the faqs ?
Jaspers05
Posts: 11
Joined: Mon Aug 11, 2014 11:11 am

Re: forgot admin password

Post by Jaspers05 »

Ok i got the same problem here (4 years later but still...).

I tried to change the password using the e-mail option, but i dont recieve the mail. Don't know why but i don't have the time yet to sort it out. I tried to reset the password using the command:

UPDATE faquserlogin SET pass = MD5('Password') WHERE login = 'username';

The table get updated but when I try to log on the system tells me the password is incorrect. I also check the table faquser and the specific users account is marked as active. so no problems there. Whats next? How to continu?

Ohh right..., I use version 2.8.12
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: forgot admin password

Post by Thorsten »

Hi,

that's not the correct passwor hashing for 2.8. Please send me an e-mail for further instructions, because I need some data from you to recover your password.

Cheers
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Jinx
Posts: 1
Joined: Thu Jan 08, 2015 5:43 pm

Re: forgot admin password

Post by Jinx »

Hello Thorsten,

I am having the same issue with my admin user. My e-mail password feature isn't working and I am trying to change this password using the phpMyAdmin. I found my account and tried changing the password using the MD5 but I seen where this no longer works in version 2.8. I could really use some help getting access to this account. Thank you.
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: forgot admin password

Post by Thorsten »

Hi,

here's a little PHP script to generate your password hash: viewtopic.php?f=7&t=16497&p=44325

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Post Reply