For When You Can't Have The Real Thing
[ start | index | login ]
start > bugzilla > Password Reset

Password Reset

Created by dave. Last edited by dave, 13 years and 177 days ago. Viewed 4,165 times. #2
[diff] [history] [edit] [rdf]

Resetting Bugzilla Passwords

(Done with 3.2)

Find yourself the crypt text of a password you know, for my example I know what "A.dsjcCzS./." translates to. Then:

# mysql -u bugs-p bugs
<password for bugs>
mysql> select userid, login_name from profiles ;
<table follows>
mysql> update profiles set cryptpassword="A.dsjcCzS./." where userid=41 ;
Query OK, 1 row affected (0.05 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> quit Bye

...presuming the userid of the user you want to change is 41.

You can't just smash the password to NULL, because if you do that you can log in with no password, but you can't change the null password to anything. Once you insert a crypt text password you can change it through the web interface again.

no comments | post comment
This is a collection of techical information, much of it learned the hard way. Consider it a lab book or a /info directory. I doubt much of it will be of use to anyone else.

Useful: | Copyright 2000-2002 Matthias L. Jugel and Stephan J. Schmidt