The files will be hosted on DreamHost, but for development purposes (aka: before client has paid), MySQL will be hosted on another host provider. Lets say MySQL will be on: Godaddy, RackSpace, JustHost, or a server at the office.
When attempting to make a simple connection, such as:
// Create connection
// Check connection
echo "Failed to connect to MySQL: " . mysqli_connect_error();
An error is received on DreamHost:
color=#800000: Can’t connect to MySQL server on ‘IPAddress’ (110)[/color]
Reading through threads, someone recommended to go to DreamHost, click on Databases, click on a db-user, and add an allowable host. I did, but that user name is not on the MySql host company anyway, how does that help?
Called the other host company to see if they could look through their logs. Nothing is showing after and different attempts and different scripts from DreamHost to connect to this different MySQL host provider.
Someone recommended SSH, but what commands would you send?