mysql无法访问目标主机,mysql_connect（）：由于目标机器主动拒绝连接，因此无法建立连接...

I have this problem when I am trying to run my PHP MySQL script. When I try to run my .php file this is what I get.

mysql_connect(): No connection could be made because the target machine actively refused it

This is code for dbconnect.php:

mysql_connect("localhost","root");

mysql_select_db("users");

?>

I tried to use this format before but I don't know what seems to be the problem with this code.

Thank you in advance.

解决方案

You forgot password in your connection.

Try this.

mysql_connect("localhost","root" ,"password here");

You should switch to MYSQLI or PDO as you see that MYSQL is already deprecated.

The initial Mysql password is blank according to this info for mysql ver 5.0. you should check your version.

mysql_connect("localhost","root" ,""); // will connect.

EDIT:

No connection could be made because the target machine actively refused it

means that no error in your code , but either you have firewall which blocks your connection or your sistem is listening in different PORT.

to do: 1-verify your connecting port default is 3306.

2-try connect with use "127.0.0.1" instead of "localhost" this maybe it listening on "127.0.0.1".

3-It could also go wrong if the other end is listening on UDP, not TCP.

4- verify your firewall connection if its permitted.