[SOLVED] Need emergency help! Upgraded MYSQL to Version 5 now passwords lost.

[virtuexru]

OK.. Here's the problem..

 

I upgraded from Version 4 to Version 5 today.

 

I had a table with users on it that had the MD5 password scramble thing.

 

But after converting to version 5, I can't login anyone? I'm assuming this has to do with whether or not I updated with LATIN or UTF or blabla, but I'm clueless as to that! Everything else works, what do I need to do to restore passwords?

[fenway]

I had a table with users on it that had the MD5 password scramble thing.

Huh?

[virtuexru]

$request = "INSERT INTO tbl_auth_user values('$user_id',PASSWORD('$pass')"

 

using the PASSWORD thing it scrambles the password when its in the actual MySQL Database itself

[fenway]

Yes, it's a hashed password. 

[virtuexru]

That's what I meant, I apologize.

 

Anyway, the "hashed" password, no longer works when I convert to MySQL 5 from version 4. Is there a workaround this?

[artacus]

Yeah, that's because they changed they way their password() works from 4 to 5.

Try OLD_PASSWORD().

[virtuexru]

OK. Well that makes sense, but what do I try OLD_PASSWORD() on? Just need a clarification? Where do I put that statement in, when someone tries to login?

[artacus]

When you are logging there will be a query like:

SELECT * FROM users WHERE user='$user' AND pword = OLD_PASSWORD('$pass')

[artacus]

Look here:

http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

[virtuexru]

Solved!! Thank you Artacus.