danielunited the password column contains a bycrypt-hashed password.
The easiest solution is to hash your new password using an online generator like https://bcrypt-generator.com/
I recommend setting a temporary password, then change it again inside Flarum, since you can't 100% trust any online generator not to log your password.
Another option would be to use an offline tool to hash the password, I think I shared the PHP command to do that in another thread.
