Groups | Search | Server Info | Login | Register

Groups > comp.databases.mysql > #530

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

Show all headers | 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