I am deploying a MySQL server behind a proxy server (apache mod_proxy). I am getting this error when I try to connect using mysql client or using php to connect to mysql server.
Lost connection to MySQL server at 'reading initial communication packet', system error: 0
I tried by setting bind-address to 0.0.0.0 and commenting it, but noting worked.
I am doing some port mapping on proxy server in addition to proxying, using proxypass. eg:
ProxyPass / 18.104.22.168:13306 ProxyPassReverse / http://22.214.171.124:13306
I have set the apache server to listen to 3306 and there is no mysql server running on proxy server.