Link to home
Start Free TrialLog in
Avatar of altariamx2003
altariamx2003Flag for Mexico

asked on

how to work with a remote mysql database ??

I got two servers: "" with linux and "" with windows

in the page load his own database but also the mysql databse located in "", most of the time the system works without problems, but from time to time the page show you this error:
Warning: mysql_connect(): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. in C:\Inetpub\vhosts\\httpdocs\users\Connections\dbnotes1.php on line 16

Fatal error: in C:\Inetpub\vhosts\\httpdocs\users\Connections\dbnotes1.php on line 16

Open in new window

that error reffers to this line:
$dbnotes1 = mysql_connect($hostname1, $username1, $password1) or trigger_error(mysql_error(),E_USER_ERROR);
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_dbnotes = "localhost";
$database_dbnotes = "xxxxxx";
$username_dbnotes = "xxxxxx";
$password_dbnotes = "xxxxxx";
$dbnotes = mysql_connect($hostname_dbnotes, $username_dbnotes, $password_dbnotes) or trigger_error(mysql_error(),E_USER_ERROR); 

$hostname1 = "";
$database1 = "xxxxxx";
$username1 = "xxxxxx";
$password1 = "xxxxxx";
$dbnotes1 = mysql_connect($hostname1, $username1, $password1) or trigger_error(mysql_error(),E_USER_ERROR);

Open in new window

Anyone know why this error happend but just sometimes??? and it is  a way to solve it??????
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

Are you sure the server  with Linux works correctly...have checked if this is an network connectivity logging for MySQL working?
Avatar of altariamx2003


hi john thx for your time.

As far as i know all work ok, this problems sometimes emerges when i try to connect the base in from
The "sometimes" points to something between pvtcloudlab and grupossc...i don't think its MySQL's ensure that there are several stress test floating on the Internet...
Avatar of Ray Paseur
Ray Paseur
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial