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

Question

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:

<?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.

Answer 1

You forgot password in your connection.

Try this.

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

Check Documentation 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.