Groups | Search | Server Info | Login | Register
Groups > comp.databases.mysql > #548
| 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 18:44 +0200 |
| Message-ID | <90bgnnFec4U1@mid.individual.net> (permalink) |
| References | <1vq9pdiivcq41$.dlg@evanplatt.sux> <4da0495d$0$65870$e4fe514c@news.xs4all.nl> <inppeb$di2$4@news.albasani.net> |
The Natural Philosopher wrote: > Luuk wrote: >> On 09-04-2011 07:39, 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 >>> >>> What I am attempting to do is, create a script on my local machine, that >>> will create the table on the actual domain database. >>> >>> 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? >> >> You need to learn about firewalls... >> >> Those things tend to STOP traffic at ports that are not allowed, like >> port 3306. >> >> So, generally, you are right, and you should be able to access your >> remote database through remoteservername:3306, Where remoteservername >> can be example.com, www.example.com, or whatever.example.com... >> >> But in most, if not all, situations there is a firewall which makes this >> impossible >> > even if its enabled at mysqld level. which it may not be. In those cases you can always use ssh tunnels, if and only if you have ssh access on the remote server (which people in most cases don't). -- //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