Re: how to connect to online database from my home machine

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> (permalink)
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

Show key headers only | View raw

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

Back to comp.databases.mysql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

how to connect to online database from my home machine richard <member@newsguy.com> - 2011-04-08 22:39 -0700
  Re: how to connect to online database from my home machine "J.O. Aho" <user@example.net> - 2011-04-09 08:29 +0200
    Re: how to connect to online database from my home machine richard <member@newsguy.com> - 2011-04-08 23:46 -0700
      Re: how to connect to online database from my home machine The Natural Philosopher <tnp@invalid.invalid> - 2011-04-09 08:57 +0100
        Re: how to connect to online database from my home machine richard <member@newsguy.com> - 2011-04-09 02:03 -0700
      Re: how to connect to online database from my home machine "J.O. Aho" <user@example.net> - 2011-04-09 13:20 +0200
  Re: how to connect to online database from my home machine Luuk <Luuk@invalid.lan> - 2011-04-09 13:56 +0200
    Re: how to connect to online database from my home machine The Natural Philosopher <tnp@invalid.invalid> - 2011-04-09 15:11 +0100
      Re: how to connect to online database from my home machine "J.O. Aho" <user@example.net> - 2011-04-09 18:44 +0200
  Re: how to connect to online database from my home machine gordonb.0caef@burditt.org (Gordon Burditt) - 2011-04-09 18:21 -0500

csiph-web