Front end for MySQL databases

[Todd Cary]

<div class="moz-text-flowed" style="font-family: -moz-fixed">I have
created a Web application for a client that uses MySQL for the
DB. Most of my experience has envolved writing a front end in Delphi
and using ODBC to give a client an ability to administer the DB (e.g. do
queries to get lists, etc.). The application is written in PHP and I am
curious what others use for front-ends to MySQL DB's.

Also, the site will only allow SSH connections and the client is using a
Windows platform.

Many thanks........

Todd

---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <mysql-thr...@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-myodbc=freebsd.csie...@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

[Ian Zabel]

I personally prefer MySQL-Front, even though its development has been
suspended. You can get it here:
http://mysqlfront.venturemedia.de/index.php?&act=ST&f=2&t=328

MySQLCC is ok: http://www.mysql.com/downloads/gui-mycc.html
SQLyog seems ok: http://www.webyog.com/sqlyog/index.html

As to connecting via SSH from windows:

Download PuTTY (putty.exe is all you really need) and put in a directory
somewhere. Then setup the SSH connection. The important part is this:
You must forward a local port to localhost:3306 on the remote server. To
do this, create a new session, then go to Connection -> SSH -> Tunnels,
and add a new forwarded port like this:

Source Port: 3306
Destination: localhost:3306
(Local)

Then click add, and then save your session.

Now when you connect to the SSH server, your local 3306 port will be
forwarded to port 3306 on the remote server. So, you can now connect
with PuTTY and then open up your MySQL front-end and connect to the DB.

Ian.

-----Original Message-----
From: Todd Cary [mailto:to...@aristesoftware.com]
Sent: Wednesday, November 27, 2002 10:57 AM
To: my...@lists.mysql.com
Subject: Front end for MySQL databases

<div class="moz-text-flowed" style="font-family: -moz-fixed">I have
created a Web application for a client that uses MySQL for the DB. Most
of my experience has envolved writing a front end in Delphi and using
ODBC to give a client an ability to administer the DB (e.g. do queries
to get lists, etc.). The application is written in PHP and I am curious
what others use for front-ends to MySQL DB's.

Also, the site will only allow SSH connections and the client is using a
Windows platform.

Many thanks........

Todd

---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <mysql-thr...@lists.mysql.com>
To unsubscribe, e-mail

<mysql-unsubscribe-ian=ezabe...@lists.mysql.com>

[Steve Yates]

On Wed, 27 Nov 2002 07:56:42 -0800, Todd Cary wrote:

>Most of my experience has envolved writing a front end in Delphi
>and using ODBC

I just wrote a short program in Delphi (using MyODBC) to pull
information from an Access MDB and update a MySQL table. Worked fine.
Uploading from the desktop is FAR faster using a TQuery and
update/insert than using a TTable, especially using multiple VALUES per
query.

- Steve Yates
- Patience: A virtue that carries a lot of wait.

~ Taglines by Taglinator - www.srtware.com ~