mysql_connect function isn't working

[Hendor]

Hi all. I've recently set up Apache 2.2 with PHP 5.2 and MySQL 5.1. I played around with SQL a bit, and now I'm trying to access it with PHP. I currently have the code:

<?php
 
# error_reporting(E_ALL);
# ini_set('display_errors', true);
 
echo "test";
 
$link = mysql_connect('localhost', 'root', '[mypassword]');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
 
?>
 

When I run the above in Firefox with my correct password, all I get is "test", verifying to myself that PHP was working when the script ran. I've also verified that the username and password correctly start MySQL though the CLI, but I don't think that's the issue here. If they were incorrect, I should get the "Could not connect" message and the MySQL error, but I get no errors at all. This makes me think the mysql_connect function itself isn't working right.

What possible mistakes could I be making? Thanks in advance.

[Hendor]

@Atli
I think that was just an extraordinarily unlikely typo. I had heard of both mysql and mysqli, and I knew I was looking for mysql. Or maybe I just copied and pasted it from somewhere without noticing the 'i'.

Thanks for the tips, I'm sure they would have worked, but after changing so many settings over the past few days, I figured that even if I had fixed the problem, one of my other changes would have messed it up and I wouldn't know that I had fixed it. An hour ago, I uninstalled everything in order to start over and then saw Markus' comment. I've now got easyPHP installed and all my earlier problems are fixed. Now I just wish that I had saved my site and database before I deleted the Apache and MySQL folders. *facepalm*

Thanks all for your help, much appreciated.

[Markus]

@Hendor
Yeah, I've been there before. You change so much in blind hope that it'll fix something. And then, when you do fix the error, you've caused other errors, and then you decide to walk away from the computer before beating it.

@Hendor
Been there too. I've lost lots of stuff doing that; thankfully, it wasn't important stuff.

Mark.

[Atli]

@Hendor
I did the same thing yesterday :)
Lost and entire MSSQL database I spent the last 2 days building.

Anyways, I'm glad you've got your sever working now.

P.S.
You should try using Linux as a server someday.
On my Ubuntu test server this entire problem would have been solved by a single command:

$sudo apt-get install php5-mysql

Easy, right? :P