I ran into an interesting issue when installing Wordpress on my
re-installed server, I could not get a database connection during
installation. I added some debugging and discovered that I had a
"Can't connect to MySQL server on" error returned after the call
to mysql_connect() in PHP.
To check the source of the issue I then tried to connect on
the command-line using the mysql client, which occurred
successfully, confirming that I was using the correct credentials
and host address (this was a remote MySQL server).
I next created a test PHP script with a simple mysql_connect()
call, and executed it with "php test.php" from the command-line,
which was also successful.
Finally I accessed test.php through a browser, where again the
connection failed.
So I was dealing with a situation where it was Apache in
particular that was unable to connect to the remote MySQL server.
Thanks to …
[Read more]