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…
Hi
I tried to with but this is what it has returned with and no luck.
=====================
mysql> use vtig1;
No connection. Trying to reconnect…
Connection id: 635249
Current database: *** NONE ***
Database changed
mysql> update vtiger_users set user_password = ‘HTy&N9@nSd$RM’, crypt_type = ” where user_name = ‘admin’;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect…
Connection id: 635254
Current database: vtig1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘‘HTy&N9@nSd$RM’, crypt_type = ” where user_name = ‘admin’’ at line 1
mysql>
=====================