note 94316 deleted from function.mysql-connect by googleguy
| From: | googleguy@php.net | Date: | Sat, 12 Jan 2013 21:22:07 +0000 |
| Subject: | note 94316 deleted from function.mysql-connect by googleguy | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-193003@lists.php.net to get a copy of this message | ||
Note Submitter: Bruce Kirkpatrick
----
On Windows Vista or above, an entry in the Windows/System32/drivers/etc/hosts file causes
mysql_connect() connections to "localhost" to timeout and never connect. This happens on
php 5.3 and above since it now uses mysql native driver which has changed it connection behavior
compared to libmysql.dll in previous versions. It is not a PHP bug, but definitely a configuration
issue for users on new windows systems.
To get around this, you must remove the entry like this:
::1 localhost
and make sure you still have:
127.0.0.1 localhost
Also, you could change the code to connect to the ip instead, but that is inconvenient if you have
many web sites.
This issue occurs on Windows Vista, Windows 7 and Windows Server 2008.