forgot admin password

[drops]

Hi,
Its stupid but I forgot admin password . 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]

Have you tried forgot password feature?


Cheers,

Jason

[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...

[Thorsten]

Hi,

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

bye
Thorsten

[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

[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]

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....

[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]

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]

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]

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

[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]

Hi,

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

bye
Thorsten