Lost ADMIN password

[Rookie]

Can anyone tell me how to retreve my ADMIN password... How can I get in to the ADMIN area to change, reset it or retreve it? I have root access ... Can anyone help pleeeees

Thanks

 

[Danil Fomichev]

You should run mysql console with the following command:
mysql -usb_user -psb_password sitebuilder.

Then please run thise query.
update sb_users set pswd=PASSWORD('new_password') where id=1

 

[Rookie]

Thanks... I'll give it a go