trouble connecting to MySql DB (PHP)

Posted by user332817 on Stack Overflow See other posts from Stack Overflow or by user332817
Published on 2010-05-04T20:55:39Z Indexed on 2010/05/04 20:58 UTC
Read the original article Hit count: 199

Filed under:
|
|
|

Hi I have the following PHP code to connect to my db.

<?php
ob_start();
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="test"; // Database name
$tbl_name="members"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");

?>

however I get the following error:

Warning: mysql_connect() [function.mysql-connect]: [2002] A connection attempt failed because the connected party did not (trying to connect via tcp://localhost:3306) in C:\Program Files (x86)\EasyPHP-5.3.2i\www\checklogin.php on line 11

Warning: mysql_connect() [function.mysql-connect]: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. in C:\Program Files (x86)\EasyPHP-5.3.2i\www\checklogin.php on line 11

Fatal error: Maximum execution time of 30 seconds exceeded in C:\Program Files (x86)\EasyPHP-5.3.2i\www\checklogin.php on line 11

I am able to add a db/tables via phpmyadmin but I cant connect using php.

here is a screenshot of my phpmyadmin page: http://img294.imageshack.us/img294/1589/sqls.jpg any help would be appreciated, thanks in advance.

© Stack Overflow or respective owner

Related posts about sql

Related posts about php