Password hashing in MySQL 4.1.0 differs from hashing in 4.1.1 and up. The 4.1.0 differences are:
Password hashes are 45 bytes long rather than 41 bytes.
The PASSWORD()
function is
nonrepeatable. That is, with a given argument
X
, successive calls to
PASSWORD(
generate different results.
X
)
These differences make authentication in 4.1.0 incompatible with
that of releases that follow it. If you have upgraded to MySQL
4.1.0, it is recommended that you upgrade to a newer version as
soon as possible. After you do, reassign any long passwords in
the user
table so that they are compatible
with the 41-byte format.
User Comments
Add your own comment.