hi every one first I should mention taht I am new in centos I have 3 servers one for web server , second : mysql server and the third one is data server . these three servers are connected to each other with a hub . in order to connect to my mysql server I created a local IP 192.168.200.200 in mysql server (the servers main ip is xxx.xxx.xxx.120) and want to connect to this server via local ip address for faster connections but when I ping 192.168.200.200 from web server I did not get any response . ow may I do this ?!
I did it but the major problem is that after 3-4 hours that the servers are running I get The following amopus error : The host xxx was blocked because of too many .... I use mysqladmin flush-hosts and it is not working and I have to reboot the server . the mysql server is ok and running but both web server an d data server that are runing apache and connect to mysql server stops working What should I do ?! I am really confused ?!
It somehow sounds like a firewall problem. What's the output of Code: iptables -L on the MySQL server?