Posted by Jerim on 08/14/07 20:18

I have a script on one server, trying to access the MySQL database on
another server. The server with the script is on an outside network,
hosted with another company. The MySQL server is here in the
office;behind a firewall. Script works fine when it is on the local
machine, but when I moved it to the offsite webserver it gives me:

Warning: mysql_connect() [function.mysql-connect]: Lost connection to
MySQL server during query in /directory/directory2/functions/
shared_data_connections.php on line 29
Unable to connect to database.

The script is:

$username = "user";
$password = "password";
$hostname = "ip_address";
$database = "database";

$connection = mysql_connect($hostname, $username, $password)
or die ("Unable to connect to database.");
$open = mysql_select_db($database, $connection)
or die ("Unable to select database.".mysql_error());
return $connection;

One obvious problem could be the firewall. But since making any
adjustments to the firewall is frowned upon around here, I want to
cover some other bases first. Want to get some evidence that it
probably isn't something else. Any other ideas? I am very certain that
the user/pass are correct and that is the correct IP address. I have
also made certain that the user has access from any host.

[Back to original message]