How to connect?

Let's say I got

$db_name = "your_database";
$username = "your_user";
$password = "your_MySQL_password";

I'm not sure about

$db_server = "mysql.server.com";

Although I got a domain name. How to find out what is SQL hostname?
If I had that hostname, would that be enough to connect to the mySQL
database (if I dont got access to the server itself, i.e. no FTP access or
similar)

Thanks in advance

On Thu, 16 Dec 2004 23:02:58 +0100, "Dakky" <NOSPAMdakky@hi.htnet.hr> wrote:

>Let's say I got
>
>$db_name = "your_database";
>$username = "your_user";
>$password = "your_MySQL_password";
>
>I'm not sure about
>
>$db_server = "mysql.server.com";
>
>Although I got a domain name. How to find out what is SQL hostname?

Ask your host.

>If I had that hostname, would that be enough to connect to the mySQL
>database (if I dont got access to the server itself, i.e. no FTP access or
>similar)

It depends. Whether you're on the right side of a firewall. Whether there's a
database listening at all. And so on...

--
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool

"Andy Hassall" <andy@andyh.co.uk> wrote in message
news:tv14s0plivluaflkr34ivbn4sn9amkm0a7@4ax.com...
>
> >Although I got a domain name. How to find out what is SQL hostname?
>
> Ask your host.

Let's say my host is theplanet.com and I really don't want to wait days to
get response so could you please tell me if you know...

> It depends. Whether you're on the right side of a firewall. Whether
there's a
> database listening at all. And so on...

Understand...

.oO(Dakky)

>Let's say I got
>
>$db_name = "your_database";
>$username = "your_user";
>$password = "your_MySQL_password";
>
>I'm not sure about
>
>$db_server = "mysql.server.com";
>
>Although I got a domain name. How to find out what is SQL hostname?

In many cases the database runs on the same machine as the webserver, so
you can simply connect to 'localhost'. Try that.

Micha

Dakky wrote:
> I'm not sure about
> $db_server = "mysql.server.com";
> Although I got a domain name. How to find out what is SQL hostname?
> If I had that hostname, would that be enough to connect to the mySQL
> database (if I dont got access to the server itself, i.e. no FTP access or
> similar)
>

ultimately andy is correct that you should consult the persons hosting
the site (if its virtual site or not).

if you have shell access to the server to modify your code... can you
use the prompt db client 'mysql' if so the chances are its on the
'localhost'
else if you have to enter a -h flag for the command its most likely else
where and thats the db's address

if you do not have shell access (ssh, ftp, telnet...etc) (?how are you
writing the code files) then you best bet is just to try 'localhost'
first then try 'yourdomain.com' just in case access is disabled from the
localhost.

.... will expound on request.

hth
JV