I've got a web application, written in PHP and mySQL, that we're moving from one Linux host (an old version of RedHat) to another (SuSE 9.1).

The web app's user names and MD5-encrypted passwords are stored in mySQL.

The problem is that, after doing a mySQL dump of the entire database from the old host to the new one, none of the old web app logons seem to work anymore.

Is there any way I can make the old, MD5-encrypted passwords stored on the old host (EXAMPLE: "990897c4fbbe8e453078d1f758c4bdc5") work correctly on the new mySQL database/PHP md5() function on the new host?

Or do I have to force everybody to change all of their passwords?

Thank you very much in advance!

I made the incorrect assumption that the md5-encrypted passwords stored in the database were, for whatever reason, incompatible between the old version of Redhat Linux/PHP and the new version of SuSE 9.1/PHP 4.3.4. That is, of course, not true.

Actually, the problem is that the "intranet" PHP application I'm migrating from the old server to the new server makes use of session variables ... in a way that's incompatible with the default settings in PHP 4.3.4.

The solution was simply to modify /etc/php.ini:

register_globals = "On";

If you're curious, you can read more about the issue here:
http://us4.php.net/register_globals