On Aug 14, 3:18 pm, Jerim <wyo...@gmail.comwrote:
Quote:
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.
My immediate thought, and this is more of a shot in the dark than
anything, but are you specifying the correct port number. It wouldn't
be an issue if you were on a local machine, but if you are connecting
to a remote host they might have MySQL running on a different port,
not to mention the SSH connection. If that doesn't help, I googled
this article which may be helpful:
http://blog.taragana.com/index.php/a...ing-query-fix/
Good luck!
