Incompatibility effect had been detected after using the function on the login form. The validation process somehow has failed, even the variable seemed OK. It was proved when I tried execute the SQL query manually. Get a common command below in both MySQL version <=4 and 5:
The MySQL <= 4 would return the result as:
While MySQL 5 would return the result as:
Just for additional information on how to resolve it, the MySQL 5 also support the old password with new built in function old_password. In order to resulting the same value of the password function in older MySQL, you may replace the old code with:
and the result is same as the previous version of MySQL:
Labels: My Share
PS: If you've benefit from this blog,
you can support it by making a small contribution.