forgot admin password
Moderator: Thorsten
forgot admin password
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
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
-
- Posts: 200
- Joined: Tue Nov 02, 2010 9:08 am
- Location: United States-Ohio
- Contact:
Re: forgot admin password
Have you tried forgot password feature?
Cheers,
Jason
Cheers,
Jason
phpMyFAQ Quality Assurance / Forum Moderator
Amazon.com Wishlist
Amazon.com Wishlist
-
- Posts: 200
- Joined: Tue Nov 02, 2010 9:08 am
- Location: United States-Ohio
- Contact:
Re: forgot admin password
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
then the next screen you will have 2 options click on the first one which will be your database
Then the 3rd screen you have to select faquser
4th screen select the user Admin by clicking on the left side the thing that looks like a pencil
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...
First login to phpmyadmin you will see a screen like below, click on Database
then the next screen you will have 2 options click on the first one which will be your database
Then the 3rd screen you have to select faquser
4th screen select the user Admin by clicking on the left side the thing that looks like a pencil
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
Amazon.com Wishlist
Re: forgot admin password
Hi,
please note that you have to encrypt the password by using MD5()
bye
Thorsten
please note that you have to encrypt the password by using MD5()
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
-
- Posts: 200
- Joined: Tue Nov 02, 2010 9:08 am
- Location: United States-Ohio
- Contact:
Re: forgot admin password
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
You do not have the required permissions to view the files attached to this post.
phpMyFAQ Quality Assurance / Forum Moderator
Amazon.com Wishlist
Amazon.com Wishlist
Re: forgot admin password
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.
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.
-
- Posts: 200
- Joined: Tue Nov 02, 2010 9:08 am
- Location: United States-Ohio
- Contact:
Re: forgot admin password
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....
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
Amazon.com Wishlist
Re: forgot admin password
Did every thing just like you wrote.
Forgot password feature say "E-Mail was sent." but i'm not receving this mail (SPAM checked).
Forgot password feature say "E-Mail was sent." but i'm not receving this mail (SPAM checked).
Re: forgot admin password
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 ?
Re: forgot admin password
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
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
Re: forgot admin password
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
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
amazon.de Wishlist
Re: forgot admin password
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.
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.
Re: forgot admin password
Hi,
here's a little PHP script to generate your password hash: viewtopic.php?f=7&t=16497&p=44325
bye
Thorsten
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
amazon.de Wishlist