Re: [Mantisbt-help] Arghh...admin password lost :)

[Jeroen L. <jl...@ca...>]

At 14:12 27-2-2003 +0100, you wrote:
>Yes it's stupid, but I forgot the admin password :) I had it stored in
>Mozillas password manager, but my prefs got swatted, and now I just
>can't remember.
>
>So, is there any way to reset the admin password? (I'm not very SQL
>savvy...)

You can install phpMyAdmin, and edit the mantis_user_table manually.

If you are using 0.18.0a1/2/3:

- Locate the row connected to your account
- Just enter your password in plaintext in the password column. It will be 
encrypted as soon as you login

If you are using earlier versions:

- Locate the row connected to your account
- Enter the password according to your encryption method (CRYPT, MD5 or 
PLAIN). If you use PLAIN, just type it in. If you use MD5, you can select 
MD5 from the drop-downbox in phpMyAdmin. If you're using CRYPT, I think you 
can select CRYPT or PASSWORD - but those might produce different results.

Good luck,

Jeroen