PHP database connection problem in webserver
Posted: Fri Aug 19, 2011 5:30 am
Hello I m new to php. I have uploaded a simple php script in my web root - http://www.mydomain.com which will connect to my DB.
But strangely I CANT connect to my DB if I put the hostname as my real hostname - mydomain.com . But if I use - localhost , it works. How come its working as- localhost when I am not on localhost.
But strangely I CANT connect to my DB if I put the hostname as my real hostname - mydomain.com . But if I use - localhost , it works. How come its working as- localhost when I am not on localhost.
Code: Select all
<?php
echo "HELLO WORLD";
$connect = mysql_connect("localhost","username","mypassword") or die ("couldn't connect db"); // it works
//$connect = mysql_connect("www.mydomain.com","username","mypassword") or die ("couldn't connect db"); // it DOESN'T work
?>