PHP Warning: mysql_connect(): Connection timed

PHP Warning: mysql_connect(): Connection timed - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: PHP Warning: mysql_connect(): Connection timed (/showthread.php?tid=609529)

PHP Warning: mysql_connect(): Connection timed - Iverso - 13.06.2016

[13-Jun-2016 11:34:49 America/Chicago] PHP Warning: mysql_connect(): Connection timed out in /home/firstgam/public_html/cp/global/class/SQL.php on line 12

Код:

<?php
 
 
 
 
// Linux Box
DEFINE('HOST', '192.99.11.136');
DEFINE('USRNM', 'f1874_test');
DEFINE('PSWD', '22665139');
DEFINE('DBNM', 'f1874_test');
 
$link = mysql_connect('192.99.11.136', 'f1874_test', '');
if (!$link) {
   die('cannot connect : ' . mysql_error());
}
echo 'Connected';
 
$db_selected = mysql_select_db('f1874_test', $link);
if (!$db_selected) {
   die ('cant select the database  : ' . mysql_error());
}
 
 
 
?>

Re: PHP Warning: mysql_connect(): Connection timed - SkillNasr - 14.06.2016

Quote:

Originally Posted by Iverso

[13-Jun-2016 11:34:49 America/Chicago] PHP Warning: mysql_connect(): Connection timed out in /home/firstgam/public_html/cp/global/class/SQL.php on line 12

Код:

<?php
 
 
 
 
// Linux Box
DEFINE('HOST', '192.99.11.136');
DEFINE('USRNM', 'f1874_test');
DEFINE('PSWD', '22665139');
DEFINE('DBNM', 'f1874_test');
 
$link = mysql_connect('192.99.11.136', 'f1874_test', '');
if (!$link) {
   die('cannot connect : ' . mysql_error());
}
echo 'Connected';
 
$db_selected = mysql_select_db('f1874_test', $link);
if (!$db_selected) {
   die ('cant select the database  : ' . mysql_error());
}
 
 
 
?>

change

Quote:

DEFINE('HOST', '192.99.11.136');

Quote:

DEFINE('HOST', 'localhost');

and

Quote:

$link = mysql_connect('192.99.11.136', 'f1874_test', '');

Quote:

$link = mysql_connect('localhost', 'f1874_test', '');

I've got that problem just a week ago

Re: PHP Warning: mysql_connect(): Connection timed - Iverso - 14.06.2016

not working

Re: PHP Warning: mysql_connect(): Connection timed - Slawiii - 14.06.2016

i got same your problem when i have a linux host
i don't know why MySQL hosted in a linux can be connected only with localhost
if you want to make it working search for a windows hosting or search for a host support MySQL + Web Hosting

For me, i sloved this problem by registering in this website mywindowshosting.com
this website giving free web hosting windows for 2 months. when you register create a database and save the info of host

Re: PHP Warning: mysql_connect(): Connection timed - Crazy_Str - 14.06.2016

mysql is no longer supported, use mysqli
And it is possible that the connection is closed from the outside

Quote:

DEFINE('HOST', '192.99.11.136');
DEFINE('USRNM', 'f1874_test');
DEFINE('PSWD', '22665139');
DEFINE('DBNM', 'f1874_test');
DEFINE('PORT', '');
$link = new mysqli(HOST, USRNM, PSWD, DBNM, PORT);
if ($link->connect_error) {
die('Error Connection (' . $link->connect_errno . ') '
. $link->connect_error);
}
$example = $link->query("SELECT * FROM `users` WHERE `userid` = '1' LIMIT 0, 1");
$result = $example->fetch_assoc();
echo $result['username'];
$link->close();

Re: PHP Warning: mysql_connect(): Connection timed - ev0lution - 14.06.2016

The FRAG MySQL server does not allow remote connections. Consider using a different MySQL host.

Re: PHP Warning: mysql_connect(): Connection timed - Vince - 14.06.2016

Quote:

Originally Posted by Slawiii

i got same your problem when i have a linux host
i don't know why MySQL hosted in a linux can be connected only with localhost
if you want to make it working search for a windows hosting or search for a host support MySQL + Web Hosting

For me, i sloved this problem by registering in this website mywindowshosting.com
this website giving free web hosting windows for 2 months. when you register create a database and save the info of host

This has nothing to do with the OS. Server providers and VPS users alike usually block remote connections from a security point of view. Only the essential ports are opened and the rest are securely closed. Admittedly, if you have a VPS you can whitelist certain IP addresses/ranges, while implicitly blacklisting all the rest.

And a word of caution: the "mysql" PHP extension is deprecated and has been completely removed from PHP 7 onwards. Use PDO or mysqli instead.

Re: PHP Warning: mysql_connect(): Connection timed - Iverso - 14.06.2016

Quote:

Originally Posted by Crazy_Str

mysql is no longer supported, use mysqli
And it is possible that the connection is closed from the outside

PHP Fatal error: Cannot use isset() on the result of an expression (you can use "null !== expression" instead) in /home/firstgam/public_html/cp/global/class/SQL.php on line 7

Re: PHP Warning: mysql_connect(): Connection timed - SecDet - 14.06.2016

Quote:

Originally Posted by SkillNasr

change

To

and

To

I've got that problem just a week ago

Why the localhost?

Manya.

Re: PHP Warning: mysql_connect(): Connection timed - Slawiii - 14.06.2016

Quote:

Originally Posted by Vince

I think it from the OS

so thanks bro now i am understanding