mysql accessed remotely

[Kenneth]

I want to know how you can access a remote mySQL database from a php script.

Also how can I connect to a remote mysql database from mysql administrator?

[Chris Hope]

Kenneth wrote:

I want to know how you can access a remote mySQL database from a php
script.
mysql_connect($ipaddress, $username, $password);

where $ipaddress is the IP address of the server you want to connect to.
Note that you may not be able to connect to a remote mysql database if
a) the firewall blocks the mysql port b) mysql is not configured to
listen to a port or c) your login doesn't have privileges to connect
remotely.
Also how can I connect to a remote mysql database from mysql
administrator?

Find the configuration dialog and set the hostname to an IP address. See
above notes about why you still may not be able to connect.

--
Chris Hope | www.electrictoolbox.com | www.linuxcdmall.com

[Kenneth]

Here is the message i get when i use

mysql_connect($ipaddress, $username, $password);
error:

Warning: mysql_connect(): Unknown MySQL Server Host 'db195.perfora.net'
(1) in /oldhome/WWW/wingsofthedawn.org/htdocs/final/Connections/myDB.php
on line 9

Fatal error: Unknown MySQL Server Host 'db195.perfora.net' (1) in
/oldhome/WWW/wingsofthedawn.org/htdocs/final/Connections/myDB.php on line 9


Chris Hope wrote:

Kenneth wrote:

I want to know how you can access a remote mySQL database from a php
script.

mysql_connect($ipaddress, $username, $password);

where $ipaddress is the IP address of the server you want to connect to.
Note that you may not be able to connect to a remote mysql database if
a) the firewall blocks the mysql port b) mysql is not configured to
listen to a port or c) your login doesn't have privileges to connect
remotely.

Also how can I connect to a remote mysql database from mysql
administrator?

Find the configuration dialog and set the hostname to an IP address. See
above notes about why you still may not be able to connect.

[Gordon Burditt]

>mysql_connect($ipaddress, $username, $password);

error:

Warning: mysql_connect(): Unknown MySQL Server Host 'db195.perfora.net'
(1) in /oldhome/WWW/wingsofthedawn.org/htdocs/final/Connections/myDB.php
on line 9

Fatal error: Unknown MySQL Server Host 'db195.perfora.net' (1) in
/oldhome/WWW/wingsofthedawn.org/htdocs/final/Connections/myDB.php on line 9

db195.perfora.net is not a valid hostname. Fix your hostname
or fix your DNS.

Gordon L. Burditt

[Kenneth]

Gordon, why is not a valid hostname. and also how do i get the ip for
db195.perfora.net?
Gordon Burditt wrote:

mysql_connect($ipaddress, $username, $password);
error:

Warning: mysql_connect(): Unknown MySQL Server Host 'db195.perfora.net'
(1) in /oldhome/WWW/wingsofthedawn.org/htdocs/final/Connections/myDB.php
on line 9

Fatal error: Unknown MySQL Server Host 'db195.perfora.net' (1) in
/oldhome/WWW/wingsofthedawn.org/htdocs/final/Connections/myDB.php on line 9

db195.perfora.net is not a valid hostname. Fix your hostname
or fix your DNS.

Gordon L. Burditt

[Chris Hope]

Kenneth wrote:

Gordon, why is not a valid hostname. and also how do i get the ip
for db195.perfora.net?

You run "nslookup db195.perfora.net" to get the IP address. This tells
you that there is no such hostname which is why Gordon would have said
it's not valid.

--
Chris Hope | www.electrictoolbox.com | www.linuxcdmall.com

[Kenneth]

So what is the next step?
Chris Hope wrote:

Kenneth wrote:

Gordon, why is not a valid hostname. and also how do i get the ip
for db195.perfora.net?

You run "nslookup db195.perfora.net" to get the IP address. This tells
you that there is no such hostname which is why Gordon would have said
it's not valid.

[Chris Hope]

Kenneth wrote:

Gordon, why is not a valid hostname. and also how do i get the ip
for db195.perfora.net?

You run "nslookup db195.perfora.net" to get the IP address. This
tells you that there is no such hostname which is why Gordon would
have said it's not valid.

So what is the next step?

Use a valid hostname. Or find out the actual IP address of the server
you are trying to connect to. It's better to use the IP address anyway
to prevent any extra latency required in looking it up each time your
script wants to connect to the server.

--
Chris Hope | www.electrictoolbox.com | www.linuxcdmall.com

[Kenneth]

Chris you were right it was behind a firewall. So now I am running
script inside the server.

Thanks.
Chris Hope wrote:

Kenneth wrote:

Gordon, why is not a valid hostname. and also how do i get the ip
for db195.perfora.net?

You run "nslookup db195.perfora.net" to get the IP address. This
tells you that there is no such hostname which is why Gordon would
have said it's not valid.

So what is the next step?

Use a valid hostname. Or find out the actual IP address of the server
you are trying to connect to. It's better to use the IP address anyway
to prevent any extra latency required in looking it up each time your
script wants to connect to the server.