How to use `bcrypt` algorithm within `encrypt` function in MySQL for verifying password?

by

You can’t. The MySQL ENCRYPT() function uses the operating system’s crypt() function — if your operating system does not support bcrypt hashes, MySQL will not support them either.

Also, do not use the MySQL ENCRYPT() function. As ircmaxell noted, any data you pass to a MySQL query may end up in server log files, so it’s potentially unsafe to use it for anything password-related.

More Related Contents:

  1. What column type/length should I use for storing a Bcrypt hashed password in a Database?
  2. Unable to AES_DECRYPT after AES_ENCRYPT in mysql
  3. Encryption at rest and/or AES_ENCRYPT
  4. How to import large sql file in phpmyadmin
  5. How to figure out size of Indexes in MySQL
  6. How do you force mysql LIKE to be case sensitive? [duplicate]
  7. MySQL Alter table causes Error: Invalid use of NULL value
  8. Delete all rows with timestamp older than x days
  9. MySQL – Cannot insert NULL value in column, but I have a default value specified?
  10. Detecting utf8 broken characters in MySQL
  11. How can I stop a MySQL query if it takes too long?
  12. “General error: 1005 Can’t create table” Using Laravel Schema Build and Foreign Keys
  13. Equivalent of MSSQL IDENTITY Column in MySQL
  14. #1060 – Duplicate column name ‘id’
  15. In what order are MySQL JOINs evaluated?
  16. Count duplicates records in Mysql table?
  17. Update multiple rows with multiple ‘where’ clauses for each individual row
  18. uninitialized constant MysqlCompat::MysqlRes (using mms2r gem)
  19. Migrating data into Firebase from MySQL
  20. MySQL – Complexity of: SELECT COUNT(*) FROM MyTable;
  21. MySQL and PDO: Could PDO::lastInsertId theoretically fail?
  22. Invoke pusher when mysql has changed [closed]
  23. How do I update an entry in MySQL using CASE for the new value?
  24. How to search JSON array in MySQL?
  25. Deleting millions of rows in MySQL
  26. Summing a comma separated column in MySQL 4 (not 5)
  27. Sequel Pro and MySQL connection failed
  28. How to count date difference excluding weekend and holidays in MySQL
  29. Execute multiple semi-colon separated query using mysql Prepared Statement
  30. mysql unique number generation

Leave a Comment