v.19.3Improvements

Now Option --password Used Without Value Requires Password from Stdin

Now option --password used without value requires password from stdin. #4230 (BSD_Conqueror)
The ClickHouse client now supports reading the password from standard input when the --password option is used without a value.

Why it matters

This feature improves security and usability by allowing users to enter their password interactively or pipe it from another process rather than specifying it directly in the command line, which can be exposed in process lists.

How to use it

Run the ClickHouse client with the --password option but without specifying a password value. The client will then prompt for the password from stdin, e.g.,

bash<br>clickhouse client --password<br>

You can also pipe the password into the client, for example:

bash<br>echo 'your_password' | clickhouse client --password<br>