Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: "J.O. Aho" <user@example.net>
Newsgroups: comp.databases.mysql
Subject: Re: how to connect to online database from my home machine
Date: Sat, 09 Apr 2011 08:29:16 +0200
Lines: 32
Message-ID: <90aclsFc0qU1@mid.individual.net>
References: <1vq9pdiivcq41$.dlg@evanplatt.sux>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Trace: individual.net LxUkTbqNKi7IlSw8SxhFEggWjpVddF9f4tQf8G/p7id0Hmg8cJ
Cancel-Lock: sha1:TKeUV8P162mkvDg9uPQjmvNq1nw=
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.17) Gecko/20110306 Gentoo/2.0.12 SeaMonkey/2.0.12
In-Reply-To: <1vq9pdiivcq41$.dlg@evanplatt.sux>
Xref: x330-a1.tempe.blueboxinc.net comp.databases.mysql:530

richard wrote:
> Specifically, what is the proper URL coding for this?
> What exactly do I replace "localhost" with?
> As there are three different ways to do this, with neither seeming to work.
> 
> 1) example.com:3000 (for reference only)
> 2) www.example.com:3000
> 3) http://example.com:3000

mysql -u<username> -p -h example.com -P 3000 <databasename>

the "-P 3000" is really only needed if the database server uses another port
than the default 3306.


> What I am attempting to do is, create a script on my local machine, that
> will create the table on the actual domain database.

I suggest you look at PHP scripts, see www.php.net/mysqli
It's easy to add other things to the script too, but you can use mysqliadmin
too for just SQL related things.

> Then, do I use the port and how do I find out exactly which port to use?
> When I created the database on the server, I saw the port number of 3306.
> Is that the port number of the table or the database(s) location?

That's the port of the database service, same port number for all users and
regardless which database or table your use.

-- 

  //Aho