I am in the process of transferring a database that has a table that contains a list of users. Their passwords have been hashed with the MySQL PASSWORD() function.
The database I have transferred it to appears to be the same version (5). But when I go to login with a username and password, it doesn’t work. I think it may be to do with the PASSWORD() hashing.
There a few hundred users stored in the table, so it’s not practical to get them all to reset their password.
It might not be the PASSWORD(), but it seems most likely.
Has anyone had any experience with this before? Any tips and advice would be greatly appreciated.