Sugar - no user name or password

[mhulbrock]

Hello everyone, hopefully you can help me with this problem. I have a client who has been using sugar for some time. It is version 5.0.0
He has always autosaved his username and password in the browser. Now he has a new computer as his old one has died. How can I help him login?
Is there a way to reset the user name and password. He has no clue what it is.
We have tired alot of combos, nothing is valid
thank you
-Mark

[sugarcane]

you can go into the database and run the following query:

UPDATE Users
SET user_hash = MD5('newpassword')
WHERE user_name = 'admin';

enter the desired password in the newpassword above and make sure you have the correct username in the WHERE statement

[mhulbrock]

Thank you! Worked.