How to transfer passwords from old MySQL database to new MySQL database?

Question

MySQL

Hi everybody!
Tell me how to transfer user passwords from the old MySQL database to the new MySQL database? The problem is that in the old database the password consists of varchar(45) and no salt, while in the new database the password consists of varchar(32) + salt varchar(3).

Answer 1

Transfer the old base completely. Then add a "salt" field. Then with PHP, Python, etc. or even manually "go through" each field and check if the password is more than 32 characters, then delete everything that comes after 32 characters, if less, then do nothing.

Answer 2

If there is no way to get the second hash from the first hash, then there is no way to transfer it. Is it possible to make a field like old_password and store the old password format there, and when logging in, check if this user has an old password and it matches, then generate a new hash based on it. As a result, over time, user hashes will be recalculated.