Reset vtiger 5.0.4 default admin password

Date 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.
  • TailRank
  • YahooMyWeb
  • del.icio.us
  • DZone
  • Facebook
  • Reddit
  • StumbleUpon
  • Digg
  • Simpy
  • Technorati

3 Responses to “Reset vtiger 5.0.4 default admin password”

  1. Eugene said:

    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’

  2. Jonathan Montenegro said:

    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’;

  3. Carlos Cristobal said:

    This one worked well for me!

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

Leave a Reply

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