Error while connecting to mysql on server

[Ezio]

Hey guys,

 

here is the problem that i am having, i am connecting to the server using these lines:

$link = mysql_connect('localhost', 'username', 'password');if (!$link) {    die('Not connected : ' . mysql_error());}

it shows the following error:

Not connected : No connection could be made because the target machine actively refused it.

what am i doing wrong..??

[Ingolme]

I'm looking this up on Google and maybe changing localhost to 127.0.0.1 will fix the problem.

[Ezio]

Yes, that worked.

But isn't localhost the same as 127.0.0.1 ?

[Ingolme]

Only if the windows hosts file says it is. It seems if you're running the server in a virtual box or sometimes simply because the hosts file got manipulated localhost might not be pointing to 127.0.0.1. You can search online about the windows hosts file if you want to learn more about it. With that file you can assign names to any IP address.

[Ezio]

That means instead of "localhost" i should write the ip address of my database, whatever it might be..??

(so should that be the practice, writing the ip instead of localhost).

Edited October 24, 2013 by Ezio

[Ingolme]

Localhost means 127.0.0.1, so that's the IP of your database.

[Ezio]

Localhost means 127.0.0.1, so that's the IP of your database.

so should that be the practice from now on, writing the ip instead of localhost..??

[Ingolme]

I always use localhost, myself. It's just something wrong with your Windows hosts file. Though writing the IP address rather than localhost will certainly ensure there are no domain name errors.

[Ezio]

Thanks a lot.