How to recover Admin Password ?

[mem94566]

Hi, The SugaCrm admin password has been changed on our server, by an employee that was fired. Is there a way to recover. I do have root access to server. All advise welcomed.

[crmsiva]

Hi

If you have DB access, you can easily change the password in users table.

[crmbalah]

HI
you should be save as md5 format.

[andopes]

UPDATE users SET user_hash = MD5('some_password') WHERE user_name = 'some_user';