Go to the first, previous, next, last section, table of contents.
Many users of MySQL have contributed very useful support
tools and add-ons.
A list of what is available at
http://www.mysql.com/Downloads/Contrib/
(or any mirror) is shown here.
Please visit our Software Portal at
http://www.mysql.com/portal/software/.
The community facilities there also allow for your input!
If you want to build MySQL support for the Perl DBI/DBD
interface, you should fetch the Data-Dumper, DBI, and
Msql-Mysql-modules files and install them.
See section 2.7 Perl Installation Comments.
Note: The programs listed here can be freely downloaded and used.
They are copyrighted by their respective owners.
Please see individual product documentation for more details on licensing and terms.
MySQL AB assumes no liability for the correctness of the information in this
chapter or for the proper operation of the programs listed herein.
- 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, whilst supporting multiple
operating systems and languages. You can currently import/export database,
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 (se-afs@dial.eunet.ch).
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 which 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 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,
david@zhadum.org.
- 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 - 3.23.7. Written
using the Tmysql components.
You can write queries and show tables, indexes, table syntax, and
administrate user, host, and database 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 ms@it-netservice.de. Original
URL http://www.it-netservice.de/pages/software/.
- http://www.mysql.com/Downloads/Win32/netadmin2.zip
New version of netadmin. See above 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 light weight 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, 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 front end 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, gilbert@ican.net but
now in public domain and supported by MySQL AB.
- http://www.mysql.com/Downloads/Contrib/xmysql-1.9.tar.gz.
xmysqlA front end to the MySQL database engine. It allows for simple
queries and table maintenance, as well as batch queries. By Rick
Mehalick, dblhack@wt.net.
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 the 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 homepage 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 front-end tool for JDBC compliant
databases written with Java 2. JRetriever displays database
tables/views in a Windows explorer-like front end. 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 back-end 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, psql (command-line based tools). It is more
flexible than TOAD, ISQL, 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 server, database, table, index,
users and to edit table data in grid or execute Sql
by Query Analysis.
- Web Clients
- http://www.mysql.com/Downloads/Contrib/mysql-editor.tar.gz
This cgi scripts in Perl enables you to edit content of Mysql
database. 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 both fields, records, and operations.
- http://www.mysql.com/Downloads/Contrib/mod_mysql_include_1.0.tar.gz
Apache module to include HTML from MySQL queries into your pages,
and run update queries. Originally written to implement a simple fast
low-overhead banner-rotation system. By Sasha Pachev.
- http://htcheck.sourceforge.net/
htCheck is a URL checker with
MySQL backend. Spidered URLs can later be queried using SQL to retrieve
various kinds of information, eg. broken links. Written by Gabriele Bartolini.
- http://www.odbsoft.com/cook/sources.htm
This package has various functions for generating html code from a SQL
table structure and for generating SQL statements (Select, Insert,
Update, Delete) from an html form. You can build a complete forms
interface to a SQL database (query, add, update, delete) without any
programming! By Marc Beneteau, marc@odbsoft.com.
- http://www.mysql.com/Downloads/Contrib/sqlhtml.tar.gz
SQL/HTML is an HTML database manager for MySQL using
DBI 1.06.
- http://www.mysql.com/Downloads/Contrib/udmsearch-3.0.23.tar.gz (UdmSearch 3.0.23, stable version).
- http://www.mysql.com/Downloads/Contrib/mnogosearch-3.1.12.tar.gz (mnogosearch 3.1.12, development but recommended version)
- http://search.mnoGo.ru/ (UdmSearch home page)
A SQL-based search engine for Internet. By
Alexander I. Barkov bar@izhcom.ru.
- http://www.mysql.com/Downloads/Contrib/wmtcl.doc
- http://www.mysql.com/Downloads/Contrib/wmtcl.lex
With this you can write HTML files with inclusions of Tcl code. By
vvs@scil.npi.msu.su.
- http://www.mysql.com/Downloads/Contrib/www-sql-0.5.7.lsm
- http://www.mysql.com/Downloads/Contrib/www-sql-0.5.7.tar.gz
A CGI program that parses an HTML file containing special tags, parses
them, and inserts data from a MySQL database.
- http://www.mysql.com/Downloads/Contrib/genquery.zip
Perl SQL database interface package for html.
- http://www.mysql.com/Downloads/Contrib/cgi++-0.8.tar.gz
A macro-processor to simply writing CGI/Database programs in C++ by Sasha Pachev.
- http://www.mysql.com/Downloads/Contrib/webboard-1.0.zip
WebBoard 1.0, EU-Industries Internet-Message-Board.
- http://www.mysql.com/Downloads/Contrib/DBIx-TextIndex-0.02.tar.gz
Full-text searching with Perl on
BLOB/TEXT columns by Daniel Koch.
- http://www.mysql.com/Downloads/Contrib/mssql2mysql.txt
Converter from MS-SQL to MySQL. By Michael Kofler.
The mssql2mysql home page is at
http://www.kofler.cc/mysql/mssql2mysql.html.
- http://www.mysql.com/Downloads/Contrib/dbf2mysql-1.14.tar.gz
Convert between `.dbf' files and MySQL tables. By Maarten
Boekhold (boekhold@cindy.et.tudelft.nl), William Volkman, and
Michael Widenius. This converter includes rudimentary read-only support
for MEMO fields.
- http://www.mysql.com/Downloads/Contrib/dbf2mysql-1.13.tgz
Convert between `.dbf' files and MySQL tables. By Maarten
Boekhold, boekhold@cindy.et.tudelft.nl, and Michael Widenius.
This converter can't handle MEMO fields.
- http://www.mysql.com/Downloads/Contrib/dbf2mysql.zip
Convert between FoxPro `.dbf' files and MySQL tables on Windows.
By Alexander Eltsyn, ae@nica.ru or ae@usa.net.
- http://www.mysql.com/Downloads/Contrib/dbf2sql.zip
Short and simple prg that can help you transport your data from foxpro
table into MySQL table. By Danko Josic.
- http://www.mysql.com/Downloads/Contrib/dump2h-1.20.gz
Convert from
mysqldump output to a C header file. By Harry Brueckner,
brueckner@mail.respublica.de.
- http://www.mysql.com/Downloads/Contrib/exportsql.txt
A script that is similar to
access_to_mysql.txt, except that this
one is fully configurable, has better type conversion (including
detection of TIMESTAMP fields), provides warnings and suggestions
while converting, quotes all special characters in text and
binary data, and so on. It will also convert to mSQL v1 and v2,
and is free of charge for anyone. See
http://www.cynergi.net/exportsql/ for the latest version. By
Pedro Freire, support@cynergi.net. Note: Doesn't work with
Access2!
- http://www.mysql.com/Downloads/Contrib/access_to_mysql.txt
Paste this function into an Access module of a database that has the
tables you want to export. See also
exportsql. By Brian Andrews.
Note: Doesn't work with Access2!
- http://www.mysql.com/Downloads/Contrib/importsql.txt
A script that does the exact reverse of
exportsql.txt. That is,
it imports data from MySQL into an Access database via
ODBC. This is very handy when combined with exportsql, because it lets you
use Access for all DB design and administration, and synchronise with
your actual MySQL server either way. Free of charge. See
http://www.netdive.com/freebies/importsql/ for any updates.
Created by Laurent Bossavit of NetDIVE.
Note: doesn't work with Access2!
- http://www.mysql.com/Downloads/Contrib/mdb2sql.bas
Converter from Access97 to MySQL by Moshe Gurvich.
- http://www.mysql.com/Downloads/Contrib/msql2mysqlWrapper-1.0.tgz
A C wrapper from
mSQL to MySQL. By alfred@sb.net
- http://www.mysql.com/Downloads/Contrib/sqlconv.pl
A simple script that can be used to copy fields from one MySQL table
to another in bulk. Basically, you can run
mysqldump and pipe it to
the sqlconv.pl script. The script will parse through the
mysqldump output and will rearrange the fields so they can be
inserted into a new table. An example is when you want to create a new
table for a different site you are working on, but the table is just a
bit different (that is - fields in different order, etc.).
By Steve Shreeve.
- http://www.mysql.com/Downloads/Contrib/oracledump
Perl program to convert Oracle databases to MySQL. Has same
output format as mysqldump. By Johan Andersson.
- http://www.mysql.com/Downloads/Contrib/excel2mysql
Perl program to import Excel spreadsheets into a MySQL database.
By Stephen Hurd shurd@sk.sympatico.ca
- http://www.mysql.com/Downloads/Contrib/T2S_100.ZIP.
Windows program to convert text files to MySQL databases. By
Asaf Azulay.
Go to the first, previous, next, last section, table of contents.
