How to setup mysql server behind a proxy server

Question

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

Lost connection to MySQL server at 'reading initial communication packet', system error: 0

I tried both commenting and puting 0.0.0.0 in mysql my.cnf noting is worked.

I might be mistaking but is the proxy mod of apache not limited to http/https protocol? Would it not require a proper proxy installation? — Zenklys, Jun 21 '11 at 08:17
@Shakti Singh It relate when it comes to setup a connection in php.(mysql_connect). it gives the same error — gihan, Jun 21 '11 at 08:26
@gihan: It is all about **configure mysql server behind a proxy server** nothing else — Shakti Singh, Jun 21 '11 at 08:27
@Zenklys I am using this because I am doing some port mapping also. I forward requests comes port 3306 in proxy to another port in mysql server which runs behind the proxy — gihan, Jun 21 '11 at 08:30
@Shakti Singh Please give me some example of how to configure the mysql server. Your answer is highly appreciate. — gihan, Jun 21 '11 at 08:32

score 0 · Accepted Answer · edited Apr 13 '17 at 12:14

0

My comment above seems confirmed by your post on server fault You cannot use the apache mod_proxy to "proxy" a mysql server.

edited Apr 13 '17 at 12:14

Community

answered Jun 21 '11 at 09:55

Zenklys

1 Answers1