Reset vtiger 5.0.4 default admin password

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!

Web Developer Freelancing Handbook

Share and Enjoy:
  • del.icio.us
  • DZone
  • Facebook
  • Reddit
  • StumbleUpon
  • Digg
  • Simpy
  • Technorati

Tags: , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="">



0.16383695602417