v.25.4New Feature

Support password based auth

Support password based auth in SSH protocol in ClickHouse. #78586 (Nikita Mikhaylov).
Adds support for password-based authentication when using the SSH protocol in ClickHouse.

Why it matters

This feature enables users to authenticate over SSH using a password, providing a simpler and more flexible authentication method compared to key-based authentication. It helps users who prefer or require password authentication to securely connect to ClickHouse over SSH.

How to use it

To use password-based SSH authentication, configure your SSH connection as usual but provide the password when prompted or configure it in your SSH client settings. ClickHouse will accept and authenticate the connection using the password.