Mochabomb

The fastest way to update your password if you forget is to edit the MYSQL database file. I tried a number of other things and then this finally worked. Thanks to another posting!

1. Open phpMyAdmin
2. Select the correct database
3. Edit “vtiger_users” table
4. Edit the field user_password='adpexzg3FUZAk'
5. Edit the filed user_hash='21232f297a57a5a743894a0e4a801fc3'
6. Edit the filed confirm_password='adoY/6Mlw8kqg'
7. login with admin/admin

This is taken from here at the VTiger forum

Or.. using mysql command line:

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| vtiger503_2009     |
+--------------------+
3 rows in set (0.01 sec)

mysql> use vtiger503_2009;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> update vtiger_users set user_hash='21232f297a57a5a743894a0e4a801fc3' where id=4;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> update vtiger_users set user_password ='adpexzg3FUZAk' where id=4;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> update vtiger_users set confirm_password='adoY/6Mlw8kqg' where id=4;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

mysql> select id,user_name from vtiger_users;
+----+--------------+
| id | user_name    |
+----+--------------+
|  1 | admin        |
|  2 | standarduser |
|  3 | gene        |
|  4 | someone     |
|  5 | guest        |
+----+--------------+
5 rows in set (0.00 sec)