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.
I'm currently working on a book for web freelancers, covering everything you need to know to get started or just get better. Want to stay updated? Sign up for my mailing list to get updates when the book is ready to be released!