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

[Tarjei K. <ta...@ch...>]

On Thu, 2003-02-27 at 14:31, Jeroen Latour wrote:
> 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.
> 
Thanks mate, but I allready fixed it after reading a couple of MySQL
howtos :)

I'll keep this for future reference though :) And phpMyAdmin looks like
it may be a nice thing to have installed in any case.

Thanks again,
Tarjei