I have tried to log into my site but have forgotten the password. I tried the lost password link which gives me a password but it just takes be back to the log in page, changed the password in myphpadmin but nothing and the recovery script doesn't work either.
is there anything else I can do?
you dont indicate what version of wordpress you are using -- is there a reason for that omission? it helps immensely to provide as MUCH information as possible when asking questions.
Verision 2.6.2
I think it has something to do with upgrading the database
Did you use the md5 hash when changing the password? Did you make sure you had the right username, too? http://www.tamba2.org.uk/wordpress/phpmyadmin/
I'm not aware of any password problems with version 2.6.2, though I know 2.6.3 is out now. You could try upgrading to that and see if it makes a difference.