v.23.5New Feature

Add bcrypt password authentication type, closes #34599

Add bcrypt password authentication type. Closes #34599. #44905 (Nikolay Degterinsky).
Added support for bcrypt password authentication type in ClickHouse.

Why it matters

This feature introduces bcrypt as a password authentication method to enhance security. Bcrypt is a widely recognized and strong hashing algorithm that helps protect user passwords from brute-force and rainbow table attacks, thereby improving overall authentication security in ClickHouse.

How to use it

To use bcrypt authentication, configure user passwords with bcrypt hashes in the user management settings. When setting or updating a password, ensure it is hashed using the bcrypt algorithm so ClickHouse can verify passwords accordingly.