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 ;
mysql> update profiles set cryptpassword="A.dsjcCzS./." where userid=41 ;
Query OK, 1 row affected (0.05 sec)
Rows matched: 1 Changed: 1 Warnings: 0mysql> quit
...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.