Enable Limit Login Attempts for Reverse Proxy (varnish/haproxy)

INSERT INTO wp_options (option_name, option_value, autoload) 
VALUES ('limit_login_client_type', 'HTTP_X_FORWARDED_FOR', 'yes')
ON DUPLICATE KEY UPDATE option_value = 'HTTP_X_FORWARDED_FOR';

Note: Ensure wp_ is the correct prefix; check the wp-config.php file for the prefix.