#34188 [Opn->Bgs]: mysql_connect can connect via localhost but *not* via TCP/IP

ID: 34188 Updated by: tony2001@php.net Reported By: ken dot senior at nrl dot navy dot mil -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: Linux 2.6.11-1.1369_FC4 PHP Version: 5.0.4 New Comment: Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Due to the volume of reports we can not explain in detail here why your report is not a bug. The support channels will be able to provide an explanation for you. Thank you for your interest in PHP. Give connect privileges to your user. Previous Comments: ------------------------------------------------------------------------ [2005-08-18 18:40:28] ken dot senior at nrl dot navy dot mil Description: ------------ Just installed FC4 OS, Apache, PHP, MySQL, and php-mysql (all via yum) and discovered a strange bug when using PHP to connect to MySQL. The only connection which will work is to a local instance of MySQL via a socket, i.e., localhost setting. However, TCP/IP connections, both local as well as to other remote MySQL servers, result in the PHP error: Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '192.168.0.4' (13) in /var/www/html/IGStime/index.php on line 720 could't connect to MySQL server Usually, the problem is just the opposite, that is being able to connect via TCP/IP but not sockets. Does anyone have a clue about this? Ken Senior ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=34188&edit=1