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
orPDO
as you see thatMYSQL
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.
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