BlameThePixel!

For the new site I'm making, I have six test users in the database. I use MD5 encryption for the passwords in the database. To remember the passwords easily, I simply use the username in lowercase.
But sometimes I can't log in! It won't let me. I try again, just to make sure I typed the right password, but it still doesn't work. The only way to solve it is to reset the password through phpMyAdmin. It doesn't occur for all the users at the same time, just for one.
My guess is that something is wrong with the phpMyAdmin settings, but that's just a guess.
What's wrong? Has anyone of you had this problem?

yes i have had this probleme actually.. the way i fixed mine is by giving up tho.

hmm, sounds strange. Does php do the md5 or mysql?

also you might like to copy your table and then compare old and new when you find it doesn't work... see if it's the script or the db.

When you sign up or change your password, then it's the PHP that does the md5. When I change the password because it doesn't work, it's the MySQL.
I'll copy the db and check for differences.

Try testing it with passwords, not encrypted. It might be the problem, that when you put them in the db, they're not being encrypted correctly. But what do I know..

Yeah, but then it wouldn't be case-sensitive. Plus it wouldn't be encrypted, which I want.

Reencrypt it later, just to see if that's the problem.

what about when you log in? I'm just taking wild stabs in the dark here. heh

(all the md5s on btp are done with php).

All the md5s except for the ones I do manually when I have to fix the problem are done with PHP.