My hosting site got hacked they have done their repairs, and I can finally get into my site, unfortunately my admin password no longer works and I can't retrieve it through the forgotten password or username option provided. I don't know what to do and I am very new at this and don't want to screw up anything. I have looked through other posts but still not 100% sure what exacly I need to do. I can access phpMyadmin but not sure what and where I need to change things. Can someone PLEASE help me. Thanks.
In most cases you can simply click the database name in phpmyadmin to browse different tables - find mdl_user table and click browse button - usually main admin is the second user in that table, when you find your user account click edit button, enter your new password to the password field and on the left side of password field select MD5 from the dropdown list - GO...
You can also use commands explained in other posts, copy some known MD5 password etc - see for example http://moodle.org/mod/forum/discuss.php?d=137889#p602607