v.21.9Improvement

Log Client IP on Authentication Failure

Log client IP address if authentication fails. #27514 (Misko Lee).
Log client IP address when authentication fails in ClickHouse.

Why it matters

This feature enhances security monitoring by logging the client's IP address upon authentication failure, helping administrators identify and investigate unauthorized access attempts.

How to use it

The feature is enabled by default when authentication fails. To utilize the logs, users should ensure their logging system or log queries capture authentication failure events to see the associated client IP addresses.