Groups | Search | Server Info | Login | Register
Groups > comp.databases.mysql > #535
| From | "J.O. Aho" <user@example.net> |
|---|---|
| Newsgroups | comp.databases.mysql |
| Subject | Re: how to connect to online database from my home machine |
| Date | 2011-04-09 13:20 +0200 |
| Message-ID | <90atnvF52nU1@mid.individual.net> (permalink) |
| References | <1vq9pdiivcq41$.dlg@evanplatt.sux> <90aclsFc0qU1@mid.individual.net> <q89g7uign9po.dlg@evanplatt.sux> |
richard wrote: > 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. connect to remote server (using port 3000): mysql -u<username> -p -h example.com -P 3000 <databasename> connect to local server (using port 3000): mysql -u<username> -p -P 3000 <databasename> see the difference? the mysql is the client tool, mysqld is the database server program. > 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"? The remote servers domain name or it's ip-number. -- //Aho
Back to comp.databases.mysql | Previous | Next — Previous in thread | Next in thread | Find similar
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