|
From: Tarjei K. <ta...@ch...> - 2003-02-27 15:25:42
|
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 |