v.23.2Improvement

Ask for Password in ClickHouse-Client When Empty Password is Wrong

Ask for the password in clickhouse-client interactively in a case when the empty password is wrong. Closes #46702. #46730 (Nikolay Degterinsky).
The clickhouse-client now prompts users interactively for a password if the provided empty password is incorrect.

Why it matters

This feature improves user experience by allowing clickhouse-client to request the correct password interactively when authentication with an empty password fails, preventing login frustration and enhancing security handling.

How to use it

When connecting with clickhouse-client, if an empty password is incorrect, the client will automatically prompt for the password interactively without additional user commands or flags needed.