MySQL Connection Fatal Error

Zakuro

I got this error when I try to run the PHP file. Anyone knows what is wrong?

Here's the error message:

Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Group\Apache2\htdocs\db_connect.php on line 3

The code:

$connection = mysql_connect("localhost","sandman","metallica") or
die("Couldn't connect.");

if ($connection) {
$msg = "Success!";
}

<html>
<head>
<title>MySQL Connection</title>
</head>
<body>

<? echo "$msg"; ?>

</body>
</html>

laserlight

It sounds like you have not enabled mysql support.

Zakuro

Hello, thanks for the reply. I still don't understand leh (sorry cause I'm a newbie in all this), how do I enable mySQL now?

laserlight

Let's see, you've installed Apache web server, and you'll installed PHP. What version of PHP did you install?

Zakuro

My PHP is 5.0.4

laserlight

I'm assuming you downloaded the zip package and extracted to say, c:\php5
Set c:\php5 to be in the system path.
Search php.ini for ";extension=php_mysql.dll"
Uncomment the line by removing the semi-colon prefix, then save php.ini
Copy php_mysql.dll from the /ext subdirectory to your php5 directory.
Restart Apache.

Zakuro

Did what you told, however got new error:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'sandman'@'localhost' (using password: YES) in C:\Program Files\Apache Group\Apache2\htdocs\db_connect.php on line 3
Couldn't connect.

GLawas

I don't know why it didn't work for you, but it most definately worked for me.

Thank you for your help. I had been trying to figure this out for quite some time.

mikawhat

Originally posted by Zakuro
Did what you told, however got new error:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'sandman'@'localhost' (using password: YES) in C:\Program Files\Apache Group\Apache2\htdocs\db_connect.php on line 3
Couldn't connect.

that error has to do with authentication i guess...
make sure your username and pass are correct and you have edited php.ini