mysql_connect("IP","un","password"); quick question.

[Demonic]

Alright when connecting to a sql data how do you find the IP used to access data?

[HuggieBear]

It doesn't have to be an IP address, it could be a hostname.

To find the IP address you could ping the hostname and the IP address will be returned, but this isn't really a PHP issue.

Regards
Huggie

[craygo]

you have to contact your host and ask for the host. If you have cpanel with your host you can click on the mysql databases then look at the access and it should be in there I know mine is called "mysqlremote" not "localhost".

Ray

[Demonic]

Thanks. Whats the other options in connecting to server?

[craygo]

There is no other option. You have to know where the mysql server is in order to connect. What hosting company are you using??

Ray

[Demonic]

I'm using mb4f.info cpanel hosting.

Im in the acp it says "localhost"

i tried just putting the domain in the part and it said:

[quote]Host 'mirage.ahplace.com' is not allowed to connect to this MySQL server in /home/*****/public_html/*****/teztport.php on line 4[/quote]

when i tried access it from another host.

[code]
<?php


mysql_connect("www.MYSITE.com","nemo_testport","*******");
mysql_select_db("nemo_testport");


$test = mysql_query("SELECT * FROM test ORDER BY id DESC");

while($thiz = mysql_fetch_array($test)){

echo $thiz['id']." : ".$thiz['keyz']."<br />";
}
?>
[/code]

[craygo]

If it is on the same box it should be

mysql_connect("localhost","nemo_testport","*******");

anything other than that you have to add to the host section in the cpanel

Ray

[Demonic]

Dang. So there isn't a easy way of getting information from my Database.

Because I'm still trying to find out how to make a licence manager.

[Demonic]

bump

[trq]

[quote]Dang. So there isn't a easy way of getting information from my Database.[/quote]

No. You need to give each domain trying to connect permissions to do so.