RE: [PHP] Alternative to phpMyAdmin
| From: | Matthew Loff | Date: | Sun, 15 Jul 2001 01:29:47 +0000 |
| Subject: | RE: [PHP] Alternative to phpMyAdmin | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-57913@lists.php.net to get a copy of this message | ||
You probably mean SSH tunnel, which is quite feasable-- Hank Marquardt
posted this earlier to the list:
--------------- BEGIN QUOTE ---------------
Works just fine ... as does postgres --
ssh -N -2 -f -C -c blowfish -L3306:yourdatabase.server.here:3306
you@yourdatabase.server.here
or the other usual tricks work too ... like going through a firewall
(fyi ... clear text on the *other* side of the firewall):
ssh -N -2 -f -C -c blowfish -L3306:db_behind_thefirewall:3306
you@firewall.running.ssh
The only oddity is that you will have to use the local host *address*
127.0.0.1 to connect from the mysql client as it normally looks for a
local socket if you use 'localhost', so your connection will be:
mysql -h 127.0.0.1
for postgres examples, change the port numbers (3306) to 5432
--------------- END QUOTE ---------------
-----Original Message-----
From: Evan Nemerson [mailto:evan@coeus-group.com]
Sent: Saturday, July 14, 2001 6:02 PM
To: php-general@lists.php.net
Subject: Re: [PHP] Alternative to phpMyAdmin
What if you were to open an SSL tunnel to the DB host, then connect
through
that???
> like you said... as long as the database provider accepts connections
> from outside, you can administer it from anywhere.
>
> if the provider doesn't accept incoming connections, no amount of
> tools and software will work for you.
>
> > -----Original Message-----
> > From: Alexander Skwar [mailto:digitalp@host.xnull.com]On Behalf Of
> > Subject: RE: [PHP] Alternative to phpMyAdmin
> >
> > > if you install mysql on a windoze machine then you can administer
> > > ANY >
> >
> > mysql database going through the socket.
> >
> > Okay, for a development this may be fine, but I still fail to see
> > how a tool that runs on your own computer (no matter if it's a
> > Windows tool, or a Linux tool) can help you administer databases
> > which are not on the same computer (unless the mysql database on the
> > providers server can be contacted from any machine and not just from
> > "localhost").
> >
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net To
contact the list administrators, e-mail: php-list-admin@lists.php.net