Groups | Search | Server Info | Login | Register

Groups > comp.databases.mysql > #531

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

Show key headers only | View raw

On Sat, 09 Apr 2011 08:29:16 +0200, J.O. Aho wrote:

> 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.

Thanks for the info.
But I think you misunderstood. I do not want to establish a database on my
local machine.
I am using an editor on my machine and want to write a file that will send
the data I create locally to the hosted server through the script.

Regardless of which I use, my editor comes up with an error saying it can't
connect.

So what do I use instead of "localhost"?

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