How do I normalize MySQL 4.1+ passwords for use with QLR Manager?
With the release of MySQL 4.1, a new method of password hashing was introduced and continues to be used. When using PHP version 4.x, QLR Manager is unable to recognize these passwords unless they are normalized to the pre-4.1 password style. This is critical because QLR Manager requires that an existing user ID and password be provided to perform the product installation. The user ID performing the installation must be using the old style password. This does not appear to be an issue when using PHP 5.0 or newer.