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

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.

Leave a Comment