I’m having trouble to connect my site to the MYSQL server. The condition is like this:
My site is running under 5 http servers and all are serve using a mysql server. Recently, I have changed the ip address of all the servers due to the ip migration at the datacenter. After the changes, all my http server having problem to connect to mysql server. It shows the error like below:
Error: Can’t connect to MySQL server on ‘123.456.789.2’ (4)
However, I tried to establish a connection by placing the http file into mysql server. Only this site can be shown up correctly. Means, there’s actually no problem with the Mysql Server.
Can I know what’s the problem actually? I guess there might be some setting of the mysql server blocking the connection from my other servers. Where do we normally do the setting for this? I’m quite new in server stuff and wish to get some advice from you all…