install
PHP 5.3 to MySQL connection error
Fri, 02/05/2010 - 20:33
While trying PHP 5.3 today my scripts could not connect to the mysql database. I was sure that everything is installed correctly, so I've searched for similar issues reported by the developers and found the following interesting bug report:
MySQL functions cannot be used with 5.3.x on Vista when using "localhost"
So after changing localhost in my connection strings to 127.0.0.1 PHP successfully connected to the MySQL server. Another workaround is to delete or comment "::1 localhost" record in the c:\windows\system32\drivers\etc\hosts file.
It seems that this problem hits almost all Vista and PHP 5.3 users (Google: Vista PHP 5.3 mysql localhost "127.0.0.1" hosts) but PHP team is not considering this problem as a bug. Definitely, it is excellent demonstration of the open source wold welcomeness to the new users :-)
Tags: 
