Re: Alternative to phpMyAdmin

Yea, I do mean SSH. Oops. On Saturday 14 July 2001 18:29, you wrote: > 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").