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