No connection could be made using mysql_* API

Question

Possible Duplicate:
mysql_fetch_array() expects parameter 1 to be resource, boolean given in select

I tried to connect mysql database.but am getting the following error.

Warning: mysql_connect(): [2002] No connection could be made because the target machine actively (trying to connect via tcp://localhost:3306) in test.php on line 5

Warning: mysql_connect(): No connection could be made because the target machine actively refused it. in test.php on line 5 Warning: mysql_close() expects parameter 1 to be resource, boolean given in test.php on line 15

test.php:

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

Is `No connection could be made because the target machine actively refused it` not very clear? — Pekka, Dec 05 '11 at 17:06
The code you have written is trying to open a connection to MySQL on the `localhost` ie the same machine that the PHP is running on ... do you have MySQL installed and running ? or are you trying to connect to a different MySQL server ? — Manse, Dec 05 '11 at 17:21

score 8 · Answer 1 · answered Feb 21 '12 at 17:06

This happened to us when running a PHP & MySQL on IIS7 in Windows Server 2008 in VirtualBox. It turns out that the Windows hosts file didn't have an IPv4 entry for localhost (127.0.0.1) so the route to MySQL on localhost was not found.

We added the following to the hosts file which resolved it:

127.0.0.1       localhost # Additional IPv4 entry
::1             localhost # Existing IPv6 localhost entry

Reference: A brief description of PHP/MySQL Localhost via IPv4 & IPv6

score 1 · Answer 2 · edited Apr 26 '12 at 14:43

1

In my.ini find string:

bind-address = 127.0.0.1

Change from localhost to network IP.

edited Apr 26 '12 at 14:43

Sergey Glotov

20,200
11
84
98

answered Apr 26 '12 at 13:24

Nikolay

11
1

thanks, that did it for me on a Windows server – sarsnake Oct 10 '12 at 21:35
bind-address = 0.0.0.0 – Slawa Feb 26 '14 at 15:37

score 1 · Answer 3 · answered Jun 18 '12 at 13:45

1

Got the same message trying to connect to 'localhost' by mistake (on a Windows server). After fixing the connection string to the correct (remote) server the error disappeared.

answered Jun 18 '12 at 13:45

Ilshat Fattakhov

11
1

score 1 · Answer 4 · answered Dec 05 '11 at 17:05

1

The MySQL server isn't running, or you have a firewall blocking port 3306.

This error message means the system did not accept the TCP connection request.

answered Dec 05 '11 at 17:05

Justin ᚅᚔᚈᚄᚒᚔ

15,081
7
52
64

Oh thank you justin.But what can be done for this type of error. – jsk Dec 05 '11 at 17:19
@jsk answer ManseUK's questions above. – Pekka Dec 05 '11 at 18:25

No connection could be made using mysql_* API

4 Answers4

Linked