MySQL Reference Manual

Clients

• Graphical clients

  • http://www.ideit.com/products/dbvis/: DbVisualizer, a freeware JDBC client to graphically visualise the data and structure of several databases simultaneously. By Innovative-IT Development AB.

  • http://www.mysql.com/downloads/gui-clients.html: MySQLGUI, the MySQL GUI client homepage. By Sinisa at MySQL AB.

  • http://www.mysql.com/Downloads/Contrib/mysql_navigator_0.9.0.tar.gz: MySQL Navigator is a MySQL database server GUI client program, distributed under GPL license. The purpose of MySQL Navigator is to provide a useful client interface to MySQL database servers, while supporting multiple operating systems and languages. You can currently import/export databases, enter queries, get result sets, edit scripts, run scripts, add, alter, and delete users, and retrieve client and server information. Uses QT 2.2. The homepage for MySQL Navigator is at http://sql.kldp.org/mysql/.

  • http://www.mysql.com/Downloads/Win32/secman.zip: A user and security management GUI for MySQL on Windows. By Martin Jeremic. The homepage for MySQL Security GUI is at http://jsoft.webjump.com/.

  • http://www.mysql.com/Downloads/Contrib/kmysqladmin-0.4.1.tar.gz.

  • http://www.mysql.com/Downloads/Contrib/kmysqladmin-0.4.1-1.src.rpm:

  • http://www.mysql.com/Downloads/Contrib/kmysqladmin-0.4.1-1.i386.rpm An administration tool for the MySQL server using QT/KDE. Tested only on Linux.

  • http://www.mysql.com/Downloads/Contrib/mysql-admin-using-java+swing.tar.gz: Java client using Swing, by Fredy Fischer ([e-mail]). You can always find the latest version at http://www.trash.net/~ffischer/admin/.

  • http://www.mysql.com/Downloads/Win32/MySQL-Maker-1.0.zip: Shareware MySQL client for Windows. It’s a WYSIWYG tool that allows you to create, change, and delete databases and tables. You can change field structure and add, change, and delete data in these tables directly without an ODBC driver. The MySQL Maker homepage is at http://www.presult.de/presult/frames/fs_mysqlmaker.html.

  • http://www.mysql.com/Downloads/Contrib/mysqlwinadmn.zip: Windows GUI (binary only) to administrate a database, by David B. Mansel, [e-mail].

  • http://home.online.no/~runeberg/myqa/: MyQA is a Linux-based query client for the MySQL Database Server. MyQA lets you enter SQL queries, execute them, and view the results, all in a graphical user interface. The GUI is roughly similar to that of the Query Analyzer client that comes with MS SQL server.

  • http://www.opex.atnet.ru/mysqlmanager/: MySQL Manager is a graphical MySQL server manager for MySQL server written in Java.

  • http://www.mysql.com/Downloads/Win32/netadmin.zip: An administrator tool for MySQL on Windows 95/98 and Windows NT 4.0. Only tested with MySQL Versions 3.23.5 through 3.23.7. Written using the Tmysql components.

    You can write queries, show tables, indexes, and table syntax, and administer users, hosts, databases and so on. This is beta and still has some bugs. You can test the program with all features. Please send bugs and hints to Marco Suess [e-mail]. Original URL http://www.it-netservice.de/pages/software/.

  • http://www.mysql.com/Downloads/Win32/netadmin2.zip: New version of netadmin. See previous item for details.

  • http://www.mysql.com/Downloads/Win32/ARTADMIN203.EXE: Atronic’s MySQL client for Windows 2.0.3.0. The home page for this can be found at http://www.artronic.hr/.

  • http://www.mysql.com/Downloads/Win32/W9xstop.zip: Utility from Artronic to stop MySQL on win9x.

  • http://bardo.hyperlink.cz/mysqlmon/: A lightweight GUI client for Windows.

  • http://www.mysqlfront.de/: MySQLfront is a very nice Windows client with lots of useful features. By Angsar Becker.

  • http://www.dbtools.com.br/: Dbtools is a tool to manage MySQL databases. Currently only for Windows. Some features:

    • Manage servers, databases, tables, columns, indexes, and users.

    • Import wizard to import structure and data from MS Access, MS Excel, Dbase, FoxPro, Paradox, and ODBC databases.

    • http://www.mysql.com/Downloads/Contrib/KMYENG113.zip: An administrator GUI for MySQL. Works only on Windows; no source. Available in English and Japanese. By Mitunobu Kaneko. Home page: http://sql.jnts.ne.jp/

  • http://www.mysql.com/Downloads/Contrib/xmysqladmin-1.0.tar.gz: An X-based frontend to the MySQL database engine. It allows reloads, status check, process control, myisamchk, grant/revoke privileges, creating databases, dropping databases, create, alter, browse, and drop tables. Originally by Gilbert Therrien, [e-mail] but now in public domain and supported by MySQL AB.

  • http://www.mysql.com/Downloads/Contrib/xmysql-1.9.tar.gz: xmysqlA frontend to the MySQL database engine. It allows for simple queries and table maintenance, as well as batch queries. By Rick Mehalick, [e-mail]. The xmysql homepage is at http://web.wt.net/~dblhack/. Requires http://bragg.phys.uwm.edu/xforms/ (xforms 0.88) to work.

  • http://www.tamos.net/sw/dbMetrix/: dbMatrix is an open source client for exploring databases and executing SQL. Supports MySQL, Oracle, PostgreSQL, and mSQL.

  • http://www.multimania.com/bbrox/GtkSQL/: GtkSQL is a query tool for MySQL and PostgreSQL.

  • http://dbman.linux.cz/: dbMan is a query tool written in Perl. Uses DBI and Tk.

  • http://www.mysql.com/Downloads/Win32/Msc201.EXE (Mascon 202):

  • http://www.mysql.com/Downloads/Win32/FrMsc202.EXE (Free Mascon 202) Mascon is a powerful Win32 GUI for administering MySQL server databases. Mascon’s features include visual table design, connections to multiple servers, data and blob editing of tables, security setting, SQL color coding, dump functionality, and much more. The Mascon home page is at http://www.scibit.com/Products/Software/Utils/Mascon.asp.

  • http://www.virtualbeer.net/dbui/: DBUI is a Gtk graphical database editor.

  • http://www.rtlabs.com/: MacSQL is a GUI for MySQL, ODBC, and JDBC databases for the Mac OS.

  • http://www.caleb.com.au/: JRetriever is a generic database frontend tool for JDBC-compliant databases written with Java 2. JRetriever displays database tables/views in a Windows Explorer-like frontend. Users can retrieve data either by clicking on the table folder or by composing their own SQL statements with our built-in SQL editor. The tool has been tested with Oracle 8 and MySQL as the backend databases. It requires JDK 1.3 from JavaSoft.

  • http://www.jetools.com/products/databrowser/: The DataBrowser is a cross-database, cross-platform data access tool. It is more user-friendly than tools like SQL Plus and psql (command-line based tools). It is more flexible than TOAD, ISQL, and PGAccess, which are GUI’s that are limitied to a single platform or database.

  • http://www.intrex.net/amit/software/: The SQL Console is a standalone java application that allows you to connect to a SQL database system and issue SQL queries and updates. It has an easy-to-use graphical user interface. The SQL Console uses JDBC to connect to the database systems, and therefore, with proper JDBC drivers, you can use this utility to connect to some of the most popular database systems.

  • http://www.mysql.com/Downloads/Contrib/mysql_mmc.zip: MySQL MMC is a GUI management tool developed using kdevelop with a very good interface completely like Microsoft Enterprise Tool (for SQL server) or Sybase Central. We can use it to manage servers, databases, tables, indexes, and users and to edit table data in grids or execute Sql by Query Analysis.

• Web Clients

  • http://www.mysql.com/Downloads/Contrib/mysqladmin-atif-1.0.tar.gz: WWW MySQL administrator for the user, db, and host tables. By Tim Sailer, modified by Atif Ghaffar [e-mail].

  • http://www.mysql.com/Downloads/Contrib/mysql-webadmin-1.0a8-rz.tar.gz: A tool written in PHP-FI to administrate MySQL databases remotely over the Web within a web browser. By Peter Kuppelwieser, [e-mail]. Updated by Wim Bonis, [e-mail]. Not maintained anymore!

  • http://www.mysql.com/Downloads/Contrib/mysqladm.tar.gz: MySQL Web Database Administration written in Perl. By Tim Sailer.

  • http://www.mysql.com/Downloads/Contrib/mysqladm-2.tar.gz: Updated version of mysqladm.tar.gz, by High Tide.

  • http://www.mysql.com/Downloads/Contrib/billowmysql.zip: Updated version of mysqladm.tar.gz, by Ying Gao. You can get the newest version from http://civeng.com/sqldemo/ (the home site).

  • http://www.mysql.com/Downloads/Contrib/myadmin-0.4.tar.gz: MyAdmin is a web-based MySQL administrator by Mike Machado. The MyAdmin home page is at http://myadmin.cheapnet.net/.

  • http://www.mysql.com/Downloads/Contrib/phpMyAdmin_2.2.0.tar.gz: A set of PHP3 scripts to adminstrate MySQL over the WWW.

  • http://www.phpwizard.net/projects/phpMyAdmin/: phpMyAdmin is a PHP3 tool in the spirit of mysql-webadmin, by Tobias Ratschiller, [e-mail].

  • http://www.mysql.com/Downloads/Contrib/useradm.tar.gz: MySQL administrator in PHP. By Ofni Thomas [e-mail].

  • http://gossamer-threads.com/perl/mysqlman/mysql.cgi: MySQLMan has similar functionality to phpmyadmin, but is written with Perl and uses html templates. By Alex Krohn.

• http://www.mysql.com/Downloads/Contrib/mysql-editor.tar.gz: This CGI script in Perl enables you to edit content of MySQL databases. By Tomas Zeman.

• http://worldcommunity.com/opensource/futuresql/: FutureSQL, by Peter F. Brown, is a free, open source rapid application development web database administration tool, written in Perl, using MySQL. It uses DBI:DBD and CGI.pm.

  FutureSQL allows one to easily set up config files to view, edit, delete, and otherwise process records from a MySQL database. It uses a data dictionary, configuration files, and templates, and allows “pre-processing” and “post-processing” on fields, records, and operations.