And again: Login problem

If it’s a recent version (post 1.0.2) changing the password directly in the database will _ensure_ that you wont be able to login using it, since it’s the password’s md5 hash that gets stored in the db, not the plaintext password itself.

md5? What’s that?
And how d?3 I get logged in again? A hate to begin all over again…

md5 is a one-way hashing algorithm which protects the password from being read by anyone.
now, that said, if you want to change the password directly in the database, search for an online tool that creates an md5 hash, and using that tool, generate an md5 hash of the password you desire and introduce the result in the database in the password field.
There are lots of such md5 creator tools on the web.

Thanks for the help, but I still can’t login. I found a md5 creator, used a simple word, got a loooooooong line of characters which I copied and pasted right into the passwordfield in the database… and guess what? Nothing ??

Delete your cookies to your site. With Safari I had the problem that it was sending the password stored in the cookie rather than what I was entering.
It would not surprise me if other browsers (IE) also experienced a similar problem.
You will now also probably have to reset your password (again), since you changed it directly in the database.
Lets see what that does for you. ??

One more time to be sure I did everything correctly:
1. I’m using Mozilla on a pc
2. Deleted all the cookies, emptied cache, deleted history etc. After that allowed cookies for all sites.
3. Downloaded md5, made a html-page with in the source the code [code]<script language="JavaScript">
hash = hex_md5("stone");
document.write(hash);
</script>[/code] and got “0a840ef45467fb3932dbf2c2896c5cbf”
4. Went to phpMyAdmin, browsed to user (jack) /password within my database, entered the string within the passwordfield and hit “go” to save it.
5. Opening Mozilla, loginscreen, jack + stone, and nothing happens!
This can’t be possible! More idea’s of what go be going wrong? I dropped the database two times and began all over again?

And by the way, shouldn’t the new password send to you (by yourself) work?
Needless to say I still can’t login… ??

If you start with a fresh install of WordPress it will tell you an initial password.
What happened when you tried to use the one it gave initially?
Were you never able to login?
You can also change the e-mail address assigned to the user in your MySQL database, then when you use the “forgot password” form you will get a e-mail at that address for sure. If the case is that you haven’t entered a e-mail address in for that user yet (or entered a bogus one).
I’m not certain why your having to use a javascript to get the md5 hash when WordPress will do it for you.

Not sure if this is related but I had a bit of trouble recently when I changed my nickname in “profile”, also changed my “Identity on blog” to the new nickname and then couldn’t login anymore… Bravely overcoming a deep psycholical fear opf databases, I finally went into phpMyAdmin to look at the users table and found out that the login name is completely separate from nickname and identity on blog, so all I had to do was log in under the same name name as before.
But isn’t that a bit illogical? I really would have expected the login to have changed as well. Or is there a good reason why it’s implemented like that?

The user always logs in with the login name that was created when the user was created. This is to prevent conflicts between two users inadvertently changing the name they use to login to the same name.
From the wordpress user interface, you cannot change the username you use to login for this and I am sure more other reasons ??

Thanks for all the tips. It’s working again, but honestly I can’t say what did the trick eventually. Not a good thing. Perhaps I’m going to make the same mistake again at a later point, but I guess it could have something to do with what Eric wrote, because I w??s playing around with new usernames etc.
Also I found out that when asking for a new password through mail, copying and pasting this into the passwordfield didn’t work. I actually had to type the characters myself. Strange, because in the case of new passwords for websites (ftp etc.) I do this all the time.

I am having the same problem every time I upgrade my local install (OS X 10.3.3), even though I do everything as per instructions (overwrite, run upgrade script etc.) and every time I can not log in even when pasting the md5 hash. I end up creating a new database and then I just move wp_users tables around. Really weird.

Strange, but the problem reoccured. I just spend the entire day playing around with wordpress and it’s stylesheets, logging in and out. And now for some reason this stops. I can’t login!!!!!
I did nothing strange except adjusting a few templates, but only on the level of dateformatting etc. Really very basic.
I’s using Mozilla as a browser, deleting all the cookies etc. etc.
I just don’t get it! This should not happen! And I’m pretty sure I did nothing wrong!

Someone? I know I have to be patient to get the wright answer, but without being able to login I can’t do anything ??
Just tried to login with the new password that WP sends to you by e-mail, but this also does’t work. After this I checked the database through phpmyadmin and saw that the password h??d been updated, but still no login.
And just to be sure I deleted all the cookies, cleared history, cleared the cache , even restarted my pc, but nothing works. I even inserted a new row into the database with a new user, new password…………

As an addition to the previous I can add that when filling in the data in the loginscreen I never receive an errorwarning when clicking the ok-button.
I think that’s also odd.