Reset VTiger 5.0.4 CRM default admin password.

Hi,

Today i am hunting regarding how to reset the default Admin password for Vtiger 5.0.4 Open source CRM Application,because i just forgot password for my admin panel,After half an hour I got the solution and worked perfectly for me. I am sharing some tricky steps for the same:-

1. Login to the mysql database.
(if you have root access of your server then)

[root@p-root]# mysql -u root

2. Using the following commands on mysql command line :-

use ‘vtiger_database_name’;

For versions < 5.0.4 :

update vtiger_users set user_password = ‘HTy&N9@nSd$RM’ where user_name = ‘admin’;

For versions 5.0.4 or later:

update vtiger_users set user_password = ‘HTy&N9@nSd$RM’, crypt_type = ” where user_name = ‘admin’;

This will reset the password to ‘admin’ & “HTy&N9@nSd$RM” is your new password for login.

Note: Replace ‘admin’ with whichever user_name you want to reset the password for.

Enjoy Linux…