Go to the first, previous, next, last section, table of contents.

C Contributed programs

Many users of MySQL have contributed very useful support tools and addons.

A list of what is available at http://www.mysql.com/Downloads/Contrib/ (or any mirror) is shown below. 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 4.10 Perl installation comments.

00-README This listing.

C.1 API's

Perl modules
- Data-Dumper-2.101.tar.gz Perl Data-Dumper module. Useful with DBI/DBD support for older perl installations.
- DBI-1.13.tar.gz Perl DBI module.
- KAMXbase1.0.tar.gz Convert between `.dbf' files and MySQL tables. Perl module written by Pratap Pereira pereira@ee.eng.ohio-state.edu, extened by Kevin A. McGrail kmcgrail@digital1.peregrinehw.com. This converter can handle MEMO fields.
- Msql-Mysql-modules-1.2209.tar.gz Perl DBD module to access mSQL and MySQL databases..
- Data-ShowTable-3.3.tar.gz Perl Data-ShowTable module. Useful with DBI/DBD support.
JDBC
- mm.mysql.jdbc-1.2c.tar.gz The mm JDBC driver for MySQL. This is a production release and is actively developed. By Mark Matthews (mmatthew@ecn.purdue.edu).
- mm.mysql.jdbc-2.0pre5.tar.gz The mm JDBC driver for MySQL. This is a pre-release beta version and is actively developed. By Mark Matthews (mmatthew@ecn.purdue.edu). The two drivers above have an LGPL license. Please check http://www.worldserver.com/mm.mysql/ for the latest drivers (and other JDBC information) because these drivers may be out of date.
- twz1jdbcForMysql-1.0.4-GA.tar.gz The twz driver: A type 4 JDBC driver by Terrence W. Zellers zellert@voicenet.com. This is commercial but is free for private and educational use.
- pmdamysql.tgz A MySQL PMDA. Provides MySQL server status and configuration variables.
C++
- mysql-c++-0.02.tar.gz MySQL C++ wrapper library. By Roland Haenel, rh@ginster.net.
- MyDAO MySQL C++ API. By Satish spitfire@pn3.vsnl.net.in. Inspired by Roland Haenel's C++ API and Ed Carp's MyC library.
- mysql++ MySQL C++ API (More than just a wrapper library). Originally by kevina@clark.net. Nowadays maintained by Sinisa at TCX.
- NJrAPI A C++ database independent library that supports MySQL.
Delphi
- delphi-interface.gz Delphi interface to libmysql.dll, by Blestan Tabakov, root@tdg.bis.bg.
- DelphiMySQL2.zip Delphi interface to libmysql.dll, by bsilva@umesd.k12.or.us
- Udmysql.pas A wrapper for libmysql.dll for usage in Delphi. By Reiner Sombrowsky.
- A Delphi interface to MySQL. With source code. By Matthias Fichtner.
- TmySQL A library to use MySQL with Delphi
- Delphi TDataset-component
mysql-ruby-2.2.0.tar.gz MySQL Ruby module. By TOMITA Masahiro tommy@tmtm.org Ruby is an Object-Oriented Interpreter Language.
JdmMysqlDriver-0.1.0.tar.gz A VisualWorks 3.0 Smalltalk driver for MySQL. By joshmiller@earthlink.net
Db.py Python module with caching. By gandalf@rosmail.com.
MySQLmodule-1.4.tar.gz Python interface for MySQL. By Joseph Skinner joe@earthlight.co.nz; Modified by Joerg Senekowitsch senekow@ibm.net
mysql_mex_1_1.tar.gz An interface program for the Matlab program by MathWorks. The interface is done by Kimmo Uutela and John Fisher (not by Mathworks). Check mysqlmex.html for more information.
mysqltcl-1.53.tar.gz Tcl interface for MySQL. Based on `msqltcl-1.50.tar.gz'. Updated by Tobias Ritzau, tobri@ida.liu.se.
MyC-0.1.tar.gz A Visual Basic-like API, by Ed Carp.
sqlscreens-1.0.1.tar.gz Tcl/Tk code to generate database screens. By Jean-Francois Dockes.
Vdb-dflts-2.1.tar.gz This is a new version of a set of library utilities intended to provide a generic interface to SQL database engines such that your application becomes a 3-tiered application. The advantage is that you can easily switch between and move to other database engines by implementing one file for the new backend without needing to make any changes to your applications. By damian@cablenet.net.
DbFramework-1.10.tar.gz DbFramework is a collection of classes for manipulating MySQL databases. The classes are loosely based on the CDIF Data Model Subject Area. By Paul Sharpe paul@miraclefish.com.
pike-mysql-1.4.tar.gz MySQL module for pike. For use with the Roxen web server.
squile.tar.gz Module for guile that allows guile to interact with SQL databases. By Hal Roberts.
stk-mysql.tar.gz Interface for Stk. Stk is the Tk widgets with Scheme underneath instead of Tcl. By Terry Jones
eiffel-wrapper-1.0.tar.gz. Eiffel wrapper by Michael Ravits.

C.2 Clients

Graphical clients
- mysqlgui homepage The MySQL GUI client homepage. By Sinisa at TCX.
- kmysqladmin-0.4.1.tar.gz
- kmysqladmin-0.4.1-1.src.rpm
- kmysqladmin-0.4.1-1.i386.rpm An administration tool for the MySQL server using QT / KDE. Tested only on Linux.
- Java client using Swing By Fredy Fischer, se-afs@dial.eunet.ch. You can always find the latest version here.
- mysqlwinadmn.zip Win32 GUI (binary only) to administrate a database, by David B. Mansel, david@zhadum.org.
- netadmin.zip A administrator tool for MySQL on Windows 95/98 and Windows NT 4.0. Only tested with MySQL 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. The is still beta and have still 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/index.html.
- xmysqladmin-1.0.tar.gz A 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 TcX.
- xmysql-1.9.tar.gz
- xmysql home page A 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. Requires xforms 0.88 to work.
- dbMetrix An open source client for exploring databases and executing SQL. Supports MySQL, Oracle, PostgreSQL and mSQL.
- GtkSQL A query tool for MySQL and PostgreSQL.
- dbMan A query tool written in Perl. Uses DBI and Tk.
- Atronic's MySQL client for Win32.
- mascon1.exe You can get the newest one from http://www.SciBit.com.
- DBUI DBUI is a Gtk graphical database editor.
Web clients
- mysqladmin-atif-1.0.tar.gz WWW MySQL administrator for the user, db and host tables. By Tim Sailer, modified by Atif Ghaffar aghaffar@artemedia.ch.
- 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, peter.kuppelwieser@kantea.it. Updated by Wim Bonis, bonis@kiss.de. Not maintained anymore!
- mysqladm.tar.gz MySQL Web Database Administration written in Perl. By Tim Sailer.
- mysqladm-2.tar.gz Updated version of `mysqladm.tar.gz', by High Tide.
- billowmysql.zip Updated version of `mysqladm.tar.gz', by Ying Gao. You can get the newest version from the home site.
- myadmin-0.4.tar.gz
- MyAdmin home page A web based mysql administrator by Mike Machado.
- phpMyAdmin_2.0.1.tar.gz A set of PHP3-scripts to adminstrate MySQL over the WWW.
- phpMyAdmin home page A PHP3 tool in the spirit of mysql-webadmin, by Tobias Ratschiller, tobias@dnet.it
- useradm.tar.gz MySQL administrator in PHP. By Ofni Thomas othomas@vaidsystems.com.
mysql-editor.tar.gz This cgi scripts in Perl enables you to edit content of Mysql database. By Tomas Zeman.

C.3 Web tools

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://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.
sqlhtml.tar.gz SQL/HTML is an HTML database manager for MySQL using DBI 1.06.
UdmSearch 2.2.1b (stable version)
UdmSearch 3.0.5 (development version)
UdmSearch home page A MySQL- and PHP- based search engine over HTTP. By Alexander I. Barkov bar@izhcom.ru.
wmtcl.doc
wmtcl.lex With this you can write HTML files with inclusions of Tcl code. By vvs@scil.npi.msu.su.
www-sql-0.5.7.lsm
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.
genquery.zip Perl SQL database interface package for html.
cgi++-0.8.tar.gz A macro-processor to simply writing CGI/Database programs in C++ by Sasha Pachev.
WebBoard 1.0 EU-Industries Internet-Message-Board.
DBIx-TextIndex-0.02.tar.gz Full-text searching with Perl on BLOB/TEXT columns by Daniel Koch.

C.4 Performance Benchmarking tools

mysql-super-smack and friends User-customizable multi-threaded tool set to benchmark MySQL. By Sasha Pachev.

C.5 Authentication tools

ascend-radius-mysql-0.7.1.patch.gz This is authentication and logging patch using MySQL for Ascend-Radius. By takeshi@SoftAgency.co.jp.
icradius 0.10 icradius readme file
checkpassword-0.81-mysql-0.6.5.patch.gz MySQL authentication patch for QMAIL and checkpassword. These are useful for management user(mail,pop account) by MySQL. By takeshi@SoftAgency.co.jp
jradius-diff.gz MySQL support for Livingston's Radius 2.01. Authentication and Accounting. By Jose de Leon, jdl@thevision.net
mod_auth_mysql-2.20.tar.gz Apache authentication module for MySQL. By Zeev Suraski, bourbon@netvision.net.il. Please register this module at: http://bourbon.netvision.net.il/mysql/mod_auth_mysql/register.html. The registering information is only used for statistical purposes and will encourage further development of this module!
mod_log_mysql-1.05.tar.gz MySQL logging module for Apache. By Zeev Suraski, bourbon@netvision.net.il.
mypasswd-2.0.tar.gz Extra for mod_auth_mysql. This is a little tool that allows you to add/change user records storing group and/or password entries in MySQL tables. By Harry Brueckner, brueckner@respublica.de.
mysql-passwd.README
mysql-passwd-1.2.tar.gz Extra for mod_auth_mysql. This is a two-part system for use with mod_auth_mysql.
pam_mysql.tar.gz This module authenticates users via pam, using MySQL.
nsapi_auth_mysql.tar Netscape Web Server API (NSAPI) functions to authenticate (BASIC) users against MySQL tables. By Yuan John Jiang.
qmail-1.03-mysql-0.6.5.patch.gz Patch for qmail to authenticate users from a MySQL table.
pwcheck_mysql-0.1.tar.gz An authentication module for the Cyrus IMAP server. By Aaron Newsome.

C.6 Converters

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.
dbf2mysql.zip Convert between FoxPro `.dbf' files and MySQL tables on Win32. By Alexander Eltsyn, ae@nica.ru or ae@usa.net.
dump2h-1.20.gz Convert from mysqldump output to a C header file. By Harry Brueckner, brueckner@mail.respublica.de.
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/prod/exportsql/ for latest version. By Pedro Freire, support@cynergi.net. Note: Doesn't work with Access2!
access_to_mysql.txt Paste this function into an Access module of a database which has the tables you want to export. See also exportsql. By Brian Andrews. Note: Doesn't work with Access2!
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 synchronize 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!
/msql2mysqlWrapper 1.0 A C wrapper from mSQL to MySQL. By alfred@sb.net
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 and 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 (ie - fields in different order, etc.). By Steve Shreeve.

C.7 Using MySQL with other products

emacs-sql-mode.tar.gz Raw port of a SQL mode for XEmacs. Supports completion. Original by Peter D. Pezaris pez@atlantic2.sbi.com and partial MySQL port by David Axmark.
MyAccess97 1.01 MyAccess is an AddIn for Access 97 and handles a lot of maintanance work for MySQL databases.
MyAccess2000 1.01 MyAccess is an AddIn for Access 2000 and handles a lot of maintanance work for MySQL databases. MyAccess-readme. By Hubertus Hiden.
radius-0.3.tar.gz Patches for radiusd to make it support MySQL. By Wim Bonis, bonis@kiss.de.

C.8 Useful tools

mysql_watchdog.pl Monitor the MySQL daemon for possible lockups. By Yermo Lamers, yml@yml.com.
mysqltop.tar.gz Sends a query in a fixed time interval to the server and shows the resulting table. By Thomas Wana.
mysql_structure_dumper.tar.gz Prints out the structure of the all tables in a database. By Thomas Wana.
structure_dumper.tgz Prints the structure of every table in a database. By Thomas Wana.
mysqlsync-1.0-alpha.tar.gz. A perl script to keep remote copies of a MySQL database in sync with a central master copy. By Mark Jeftovic. markjr@easydns.com
MySQLTutor. MySQLTutor. A tutor of MySQL for beginners
MySQLDB.zip A COM library for MySQL by Alok Singh.
MySQLDB-readme.html
mysql_replicate.pl Perl program that handles replication. By elble@icculus.nsg.nwu.edu
DBIx-TextIndex-0.02.tar.gz Perl program that uses reverse indexing to handle text searching. By Daniel Koch.

C.9 RPMs for common tools (Most are for RedHat 6.1)

C.10 Useful functions

mysnprintf.c sprintf() function for SQL queries that can escape blobs. By Chunhua Liu.

C.11 Uncategorized

findres.pl Find reserved words in tables. By Nem W Schlecht.
handicap.tar.gz Performance handicapping system for yachts. Uses PHP. By rhill@stobyn.ml.org.
hylalog-1.0.tar.gz Store hylafax outgoing faxes in a MySQL database. By Sinisa Milivojevic, sinisa@mysql.com.
mrtg-mysql-1.0.tar.gz MySQL status plotting with MRTG, by Luuk de Boer, luuk@wxs.nl.
wuftpd-2.4.2.18-mysql_support.2.tar.gz Patches to add logging to MySQL for WU-ftpd. By Zeev Suraski, bourbon@netvision.net.il.
wu-ftpd-2.6.0-mysql.4.tar.gz Patches to add logging to MySQL for WU-ftpd 2.6.0. By, takeshi@SoftAgency.co.jp, based on Zeev Suraski wuftpd patches.
Old-Versions Previous versions of things found here that you probably won't be interested in.

Go to the first, previous, next, last section, table of contents.