I have a unique problem. I was messing around with MySQL and decided to try changing my admin login password using MySQL. Here is the query I used.
UPDATE wp_users SET user_pass = PASSWORD('mypass') WHERE ID = 1;
It worked beautifully. Only problem is, that I cannot login now. I am using wordpress on the standard apache 2, php5, MySQL 5 set up. Anybody have any ideas on how to get around this? (BTW the PASSWORD('mypass') part allows the password to be hashed.) I have tried changing the password to not hash but this doesnt work either. I also have the mail settings turned off, so my password cannot be emailed to me. I looked through the php_login.php page and I cant seem to sort out how the login page is passing the password into MySQL so I can login.