How Reset A Password in SugarCRM 6.x

After a few hours of saying “I can’t believe this is not here”.  I realized that a very elementry feature is missing from the SugarCRM administrator tool.

The ability to manually set a user’s password.  Not sure if this is an oversight or just a bad design moved, but none the less SugarCRM 6.1 does lack this ability.

To reset or set a password in SugarCRM you will need access to the mySQL server database.    The easiest approach in my opinion is to use the mySQL Workbench.   You can use phpmyAdmin or simply a ssh connection to the server.

Once connected to the database you will need run the following sql statement  replacing _newpassword & _username_ I have below.

 
update users set user_hash = md5('_newpassword_') where user_name = '_username_';
Hope this helps someone save some time.

Categories: CRM

One thought on “How Reset A Password in SugarCRM 6.x

  1. Pingback: My Story

Leave a comment