Mysql – How to setup thesql server behind a proxy server

apache-2.2mod-proxyMySQLreverse-proxy

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.

Best Answer

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

Related Solutions

MySQL – InnoDB Error: Log File ./ib_logfile0 is of Different Size

InnoDB is insanely picky about it's config; if something's not right, it'll just give up and go home. To make a change to the log file size without data loss:

Revert any config changes you've made to the log file size and start MySQL again.
In your running MySQL: SET GLOBAL innodb_fast_shutdown=0;
Stop MySQL
Make the configuration change to the log file size.
Delete both log files.
Start MySQL. It will complain about the lack of log files, but it'll create them and all will be well.

Mysql – Can not connect to the sql database

do you connect from php to 127.0.0.1 ?

are you sure you have restarted your mysql after changing the configuration file?

can you connect to mysql using command line:

mysql -uroot -psomePass -h127.0.0.1

do you see on what port mysql listens? can it be it is non-standard port?

netstat -lanp|grep mysqld|grep LISTEN

is it possible that your iptables does not allow connections over loopback? run

iptables -I INPUT -i lo -j ACCEPT
iptables -I OUTPUT -o lo -j ACCEPT

Best Answer

Related Solutions

MySQL – InnoDB Error: Log File ./ib_logfile0 is of Different Size

Mysql – Can not connect to the sql database

Related Topic