Admin Password Change or Retrieval

[lschuler]

Is there a way to recover the admin password that I set up when I installed it. or a way to change it. I forgot what it was.

TIA
Lance

[Thorsten]

I'll implement such a feature in phpMyFAQ 1.4.0. Do you have phpMyAdmin installed?

bye
Thorsten

[lschuler]

yup, sure do. PHPAdmin that is.

[Thorsten]

Okay, open phpMyAdmin, look for the table faquser and open it. Then edit it and change the password for the user "admin" with the variable MD5().

bye
Thorsten

[lschuler]

With the variable MD5()? You mean actually type MD5() in the password field? Including brackets? Then what.

[Thorsten]

Yes, you're right, type, not variable.

bye
Thorsten

[jaygee]

I am having the same problem as lschuler did. I need to reset my admin password, because the email functionality is not working to send my password to me. I reset the admin password to MD5() . But when I try to login, it doesn't authenticate and I cant get in. Any help is much appreciated.

[matteo]

Hi,

Any help is much appreciated.

open phpMyAdmin, select the right database and execute the SQL query below:

Code: Select all

UPDATE
    faquser
SET
    pass = MD5('password')
WHERE
    id = 1

Ciao,
Matteo

[jaygee]

Matteo,

I did what you said, and the table updated. However, I don't know what I just did. Did that reset the password to admin? How do I login after making that UPDATE?

Thanks again.

[jaygee]

O.K., I see now. I was actually setting the password variable to be PASSWORD . That worked. Thanks very, very much.