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.