Hi Team, HAProxy is not supporting MySQL-8.0 default user authentication plugin (caching_sha2_password).
HAProxy verison info : $ haproxy -vv HA-Proxy version 1.5.18 2016/05/10 Copyright 2000-2016 Willy Tarreau <wi...@haproxy.org> Build options : TARGET = linux2628 CPU = generic CC = gcc CFLAGS = -O2 -g -fno-strict-aliasing OPTIONS = USE_LINUX_TPROXY=1 USE_ZLIB=1 USE_REGPARM=1 USE_OPENSSL=1 USE_PCRE=1 Default settings : maxconn = 2000, bufsize = 16384, maxrewrite = 8192, maxpollevents = 200 Encrypted password support via crypt(3): yes Built with zlib version : 1.2.3 Compression algorithms supported : identity, deflate, gzip Built with OpenSSL version : OpenSSL 1.0.1e-fips 11 Feb 2013 Running on OpenSSL version : OpenSSL 1.0.1e-fips 11 Feb 2013 OpenSSL library supports TLS extensions : yes OpenSSL library supports SNI : yes OpenSSL library supports prefer-server-ciphers : yes Built with PCRE version : 7.8 2008-09-05 PCRE library supports JIT : no (USE_PCRE_JIT not set) Built with transparent proxy support using: IP_TRANSPARENT IPV6_TRANSPARENT IP_FREEBIND Available polling systems : epoll : pref=300, test result OK poll : pref=200, test result OK select : pref=150, test result OK Total: 3 (3 usable), will use epoll. $ Error Info : Sep 27 04:22:55 localhost haproxy[29022]: Server mysql-cluster/node1 is DOWN, reason: Layer7 wrong status, code: 0, info: "Client does not support authentication protocol requested by server; consider upgrading MySQL client", check duration: 0ms. 1 active and 0 backup servers left. 0 sessions active, 0 requeued, 0 remaining in queue. Sep 27 04:22:56 localhost haproxy[29023]: Server mysql-cluster/node2 is DOWN, reason: Layer7 wrong status, code: 0, info: "Client does not support authentication protocol requested by server; consider upgrading MySQL client", check duration: 0ms. 0 active and 0 backup servers left. 0 sessions active, 0 requeued, 0 remaining in queue. -- Best Regards, *Ramesh Sivaraman* *Senior QA Engineer, Percona* http://www.percona.com/ <http://percona.com/> Phone : +91 8606432991 Skype : rameshvs02