Posted over 8 years ago. Visible to the public.

Reset SugarCRM admin password via sql

If you are not able to get access to a sugarcrm installation you can reset the admin password directly via the sql interface.

First you need to find the active admin account in the database table users. It has the column is_admin set to 1 and the column status set to active. The code below should return a list of all active admin users.

SELECT user_name FROM users WHERE is_admin = '1' AND status = 'Active';

The password is simply a md5 hash, therefore you can set it to any value you like via:

UPDATE users SET user_hash = MD5('PASSWORD') WHERE user_name = 'USERNAME';

Owner of this card:

Last edit:
almost 6 years ago
by jan0sch
Posted by jan0sch to jan0sch's deck
This website uses short-lived cookies to improve usability.
Accept or learn more