Reset vtiger 5.0.4 default admin password

May 12, 2008

I had to seach around for this, and still had to piece together the info. Apparently people have some sort of reluctance to just give you the actual SQL statements to run. Yes, the table names *might* be different if you choose non-default prefixes, for example, or you’ve done major modifications, but I suspect you’ll be able to figure out the diffs based on the following statement(s):

> mysql -u user -ppass

mysql> use vtiger;

mysql> update vtiger_users set user_hash=’21232f297a57a5a743894a0e4a801fc3′, user_password=’adpexzg3FUZAk’,confirm_password=’adoY/6Mlw8kqg’,crypt_type=” where user_name=’admin’;

This will reset the ‘admin’ username to password ‘admin’ using vtiger 5.0.4.

Hope that helps someone, and I hope I never need to do that again.

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.

Category Posted in General

3 Responses to “Reset vtiger 5.0.4 default admin password”

Eugene said:

November 7th, 2008 at 11:49 am

SQL query:

UPDATE vtiger_users SET user_hash = ’21232f297a57a5a743894a0e4a801fc3′,
user_password = ’adpexzg3FUZAk’,
confirm_password = ’adoY / 6Mlw8kqg’,
crypt_type = ” WHERE user_name = ’admin’

MySQL said: Documentation
#1054 – Unknown column ‘â€™adminâ€™’ in ‘where clause’
Jonathan Montenegro said:

September 29th, 2009 at 10:01 am

Hi

the current query had a little syntax error, this is the right query:

update vtiger_users set user_hash=’21232f297a57a5a743894a0e4a801fc3′, use
r_password=’adpexzg3FUZAk’,confirm_password=’adoY/6Mlw8kqg’,crypt_type=”" where user_name=’admin’;
Carlos Cristobal said:

October 28th, 2009 at 10:11 am

This one worked well for me!

UPDATE vtiger_users SET user_hash = ‘21232f297a57a5a743894a0e4a801fc3′,
user_password = ‘adpexzg3FUZAk’,
confirm_password = ‘adoY/6Mlw8kqg’ WHERE user_name = ‘admin’