I’m getting below error while trying to connect the (MYSQL) DB server with the VIP IP when i use “option mysql-check user haproxy” parameter in haproxy configuration file. However if i comment this parameter the mysql connection works fine.
Error:
ERROR 2013 (HY000): Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0
Environment details:
OS-RHEL-8.6
MYSQL-8.0.36
Haproxy-1.8.27
Regards,
Vinoth