Following this answer mysql does not support bcrypt because system does not support them either.
How to add support of bcrypt to Debian to MySQL?
I wrote a User Defined Function (UDF) that can be compiled and loaded for MySQL or MariaDB:
You can install bcrypt
from the Unstable Debian repository.