2. PHPRunner General questions
  3. bcrypt
This topic is locked

bcrypt

 		7/18/2020 7:28:31 PM
PHPRunner General questions
brito author

good evening
I need a help with my database encryption, I recently switched MD5 to the bcrypt algorithm.
update my_tab set password = MD5 (password)
I just don't know how to do it with bcrypt.
someone would have the command ...
thank you
M
 		MikeT 7/19/2020

I'm not sure what you actually want to do need: there's a help page for bcrypt in phpr: https://xlinesoft.com/phprunner/docs/secapi_password_hashing.htm
If you need to migrate existing users with MD5 hashes, you'd need to either force each user to reset his/her password, or implement some workaround code that uses the existing hash in the db and migrates this hash to a new column with bcrypt.
brito author 7/19/2020



I'm not sure what you actually want to do need: there's a help page for bcrypt in phpr: https://xlinesoft.com/phprunner/docs/secapi_password_hashing.htm
If you need to migrate existing users with MD5 hashes, you'd need to either force each user to reset his/her password, or implement some workaround code that uses the existing hash in the db and migrates this hash to a new column with bcrypt.


when I deployed MD5 to the project, I used this command in mysql to convert the password field to MD5 update my_tab set password = MD5 (password), only now I can't do the same thing with bcrypt
Admin 7/19/2020

Switching from plain text passwords to MD5 or bcrypt is possible. Switching from MD5 to bcrypt is not possible and this is the whole point of password hashing.
You can make that switch in the project settings and then let users reset their passwords.