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.

Answer 2

This error is NOT password related.

Password related errors display a response from MySQL server. The subject response is NOT coming from MySQL server, but from the client itself. It could not connect to the server because the MACHINE (not the server) refused it, so, it was more likely to be a network issue or some other thing.

Try connecting to 127.0.0.1. Also check the port you are connecting to and which port is mysql running. Check for firewalls blocking connections. Are you sure is MySQL Server running?

This answer may have additional info: PHP -MySQL:No connection could be made