new php5 installation doesn't work with MySQL

[davidklonski]

Hello

I have been working with MySQL under PHP 4.3.4 successfully.
I just upgraded to PHP 5.0 and for some reason I cannot interact with MySQL anymore.

Even the following simple code does nothing:

<?php
$link = mysql_connect('localhost', 'root', '');
if (!$link) {
   die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?> 

I can connect to MySQL without any problem using the shell commands. I have MySQL running as a service for Windows XP.

It seems like there is a configuration problem between PHP and MySQL.

Does anyone have any idea what could be wrong?

[mrhappiness]

and you get no result from mysql_error() ?

[davidklonski]

I get nothing.

I tried the following:
I uncommented the extension line in php.ini:
extension=php_mysql.dll

and now I was able to connect.
This is strange. I would suspect that such important extension would be enabled by default.

[laserlight]

There was some talk about MySQL no longer being supported by default in PHP5, quite some time ago.