I ashed a question How to make Wordpress independent of hostname recently, and followed the advice by editing the mysql details.
This seemed quite successful and the Wordpress installation seemed to work.
I wanted to run
wp-admin but could no longer login with the password.
I note passwords are stored in the database encrypted, so I guess this may involve the hostname.
My question is how can I reset/modify the password? There is a option to reset password by email, but this could not send an email (email probably never been used)