473,243 Members | 1,605 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,243 software developers and data experts.

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
Jul 17 '05 #1
4 1723
On Thu, 16 Dec 2004 23:02:58 +0100, "Dakky" <NO*********@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 / <an**@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool
Jul 17 '05 #2
"Andy Hassall" <an**@andyh.co.uk> wrote in message
news:tv********************************@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...
Jul 17 '05 #3
.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
Jul 17 '05 #4
JV
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
Jul 17 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

22
by: James Kupernik | last post by:
Hello everyone! I'm hoping someone can shed some light on my ever daunting mysql/php problem. I'm currently trying to get a new server up and running using apache/php/mysql. Everything runs...
4
by: Steve Smith | last post by:
I have just installed db2 connect v8.1 (personal edition) on my PC - and reinstalled DB2 Application development client (again v8.1 FP4). When trying to use this to connect via CLI to an AS/400...
6
by: Jerry Orr | last post by:
We are trying to determine the easiest (and cheapest) way to get connections for about 50 Win2K workstations on our LAN to DB2 on a z/OS server. We could install DB2 Connect Personal Edition on...
30
by: aka | last post by:
Hi I have a DB2 v8.1 on AIX and DB2 Connect EE on Solaris wich is connected to OS/390 DB2 subsystems via APPC / SNA. I have cataloged the DB2 Connect instance as tcpip node and then the Host DB...
0
by: Zorba.GR | last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager...
5
by: mayamorning123 | last post by:
A comparison among six VSS remote tools including SourceOffSite , SourceAnyWhere, VSS Connect, SourceXT, VSS Remoting, VSS.NET To view the full article, please visit...
5
by: rAinDeEr | last post by:
Hi, Y'day one of my friend showed me how to connect to a Oracle database as SYSDBA, DBA etc I have DB2 UDB installed in Linux machine.Right now, I have a user WADI which has got some...
14
by: Marcus | last post by:
I have a function that simply returns TRUE if it can connect to a particular Sql Server 2005 express, or FALSE if it cannot. I am getting some strange error codes returned when the computer that...
2
by: zgh1970 | last post by:
Hi, All, I have question on DB2 CONNECT configure. We installed DB2 ESE V8 FixPak 14 o AIX . When we set up the connection to DB2 Mainframe. We just catalog node and DB directory without DCS....
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.