How to connect to MySQL when using FastCGI for PHP under Apache on Windows Vista

I configured PHP to use Apache mod_fcgid. PHP is working, but after changes in configuration I am not able to connect to MySQL via PHP. How to fix this?

To check MySQL connection I use the following PHP code:

error_reporting(E_ALL);

$link = mysql_connect('127.0.0.1', 'root', 'password_here');
if (!$link) {
    die('Could not connect. Error message: <' . mysql_error() . '>');
}
echo 'Connected successfully';

Error message returned by mysql_error() is empty.

I use the following configuration in Apache:

LoadModule fcgid_module modules/mod_fcgid.so
<IfModule fcgid_module>  
AddHandler fcgid-script .fcgi .php  
DefaultInitEnv PHPRC "C:/Program Files/php5"
DefaultInitEnv PHP_FCGI_MAX_REQUESTS      1000  
MaxRequestsPerProcess       1000  
MaxProcessCount 15
IPCCommTimeout 120
IdleTimeout 120
FCGIWrapper "C:/PROGRA~1/php5/php-cgi.exe" .php  
AddType application/x-httpd-php .php  

DefaultInitEnv PATH "C:/PROGRA~1/MYSQL/MYSQLS~1.0/LIB/OPT;C:/PROGRA~1/APACHE~1/APACHE2.2/BIN;C:/WINDOWS/system32;C:/WINDOWS"
</IfModule>  

PHP 5.3.1, Apache/2.2.14开发者_如何学编程 (Win32), MySQL 5.0.67-community-nt, Windows Vista Home Premium Service Pack 1. I downloaded binaries of mod_fcgid from http://www.apachelounge.com/download/mods/mod_fcgid-2.2b-w32.zip

EDIT:

I used phpinfo() to compare configuration. "Loaded Configuration File" is the same for both with and without mod_fcgid. mysql section is the same for both configs. What I found out that Environment section when mod_fcgid is turned on contains only FastCGI related variable (4 items only), while without mod_fcgid - much more.

EDIT:

I obtain the following warning:

Warning: mysql_connect() [function.mysql-connect]: in E:\ ... \testphp\mysql.php on line 7

EDIT

Error log of mysql contain no any errors on mysql_connect().

Are you sure that Warning: mysql_connect() [function.mysql-connect]: in E:\ ... \testphp\mysql.php on line 7
is the full error ? Because that's unusual it should say what's wrong there.
Also please check your mysql server's log file for any anomalies and post them here. mysql error log documentation.

Have you tried running php_info() to see if the mysql module is present and configured for your CGI? The ini configuration can be different between CGI and other method of launching.

Got the same problem and solved it this way:

1. Edit your php.ini file of cgi version (vi /etc/php5/cgi/php.ini)
2. Add the following line: extension=mysql.so
3. Restart your Apache (service apache2 reload AND /etc/init.d/apache3 restart)