[x] I am aware that this PR may be closed if the above-mentioned criteria are not fulfilled.
Changes Proposed
Hashing a password with transformToSHA1 returns bytes, but the database is storing the hex representation of it instead. When reading from the database,UNHEX the field so that the bytes are read in the server.
Please do not rewrite passwords in the database to bytes since future work might require encoded hashes that are to be stored as strings (i.e. PBKDF2, scrypt or Argon2)
Pull Request Prelude
Changes Proposed
Hashing a password with
transformToSHA1returns bytes, but the database is storing the hex representation of it instead. When reading from the database,UNHEXthe field so that the bytes are read in the server.Please do not rewrite passwords in the database to bytes since future work might require encoded hashes that are to be stored as strings (i.e. PBKDF2, scrypt or Argon2)