Friday, April 20, 2007

Change sugarCRM password from backend

If you forget your sugar admin password then dont be panic.
Can reset it from the mysql backend.

Connect to your sugar mysql database and execute this query:

For sugar version < style="font-family:verdana;">
update users set user_password=MD5('NewPass') where user_name='admin';

For sugar version >= 45
update users set user_hash=MD5('NewPass') where user_name='admin';

No comments:

Whats new in Ajuby 0.5