MySQL - B. Contributed Programs

B Contributed Programs

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 below.

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 each 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.

B.1 APIs

• Perl Modules
  • http://www.mysql.com/Downloads/Contrib/Data-Dumper-2.101.tar.gz Perl Data-Dumper module. Useful with DBI/DBD support for older Perl installations.
  • http://www.mysql.com/Downloads/Contrib/DBI-1.18.tar.gz Perl DBI module.
  • http://www.mysql.com/Downloads/Contrib/KAMXbase1.2.tar.gz Convert between `.dbf' files and MySQL tables. Perl module written by Pratap Pereira pereira@ee.eng.ohio-state.edu, extended by Kevin A. McGrail kmcgrail@digital1.peregrinehw.com. This converter can handle MEMO fields.
  • http://www.mysql.com/Downloads/Contrib/Msql-Mysql-modules-1.2218.tar.gz Perl DBD module to access mSQL and MySQL databases.
  • http://www.mysql.com/Downloads/Contrib/Data-ShowTable-3.3.tar.gz Perl Data-ShowTable module. Useful with DBI/DBD support.
  • http://www.mysql.com/Downloads/Contrib/HandySQL-1.1.tar.gz HandySQL is a MySQL access module. It offers a C interface embedded in Perl and is approximately 20% faster than regular DBI.
• JDBC
  • http://www.mysql.com/Downloads/Contrib/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).
  • http://www.mysql.com/Downloads/Contrib/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.
  • http://www.caucho.com/projects/jdbc-mysql/index.xtp The Resin commercial JDBC driver, which is released under Open Source. It claims to be faster than the mm driver, but we haven't received that much information about this yet.
  • http://www.mysql.com/Downloads/Contrib/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. (Not supported anymore.)
  • http://www.mysql.com/Downloads/Contrib/pmdamysql.tgz A MySQL PMDA. Provides MySQL server status and configuration variables.
• OLEDB
  • http://www.mysql.com/Downloads/Win32/MyOLEDB.exe OLEDB handler for MySQL. By SWsoft.
  • http://www.mysql.com/Downloads/Win32/MySamples.zip Examples and documentation for MyOLEDB. By SWsoft.
  • http://www.mysql.com/Downloads/Win32/Myoledb.zip Source for MyOLEDB. By SWsoft.
  • http://www.mysql.com/Downloads/Win32/MyOLEDB.chm Help files for MyOLEDB.
  • http://www.mysql.com/Downloads/Win32/libmyodbc.zip Static MyODBC library used for build MyOLEDB. Based on MyODBC code.
• C++
  • http://www.mysql.com/Downloads/Contrib/mysql-c++-0.02.tar.gz MySQL C++ wrapper library. By Roland Haenel, rh@ginster.net.
  • http://www.mysql.com/Downloads/Contrib/MyDAO.tar.gz MySQL C++ API. By Satish spitfire@pn3.vsnl.net.in. Inspired by Roland Haenel's C++ API and Ed Carp's MyC library.
  • http://www.mysql.com/download_mysql++.html MySQL C++ API (more than just a wrapper library). Originally by kevina@clark.net. Nowadays maintained by Sinisa at MySQL AB.
  • http://nelsonjr.homepage.com/NJrAPI/ A C++ database independent library that supports MySQL.
• Delphi
  • http://www.mysql.com/Downloads/Contrib/DelphiMySQL2.zip Delphi interface to libmysql.dll, by bsilva@umesd.k12.or.us.
  • http://www.mysql.com/Downloads/Contrib/Udmysel.pas A wrapper for libmysql.dll for usage in Delphi. By Reiner Sombrowsky.
  • http://www.fichtner.net/delphi/mysql.delphi.phtml A Delphi Interface to MySQL, with source code. By Matthias Fichtner.
  • http://www.productivity.org/projects/tmysql/ TmySQL, a library to use MySQL with Delphi.
  • http://www.geocities.com/CapeCanaveral/2064/mysql.html Delphi TDataset-component.
  • http://www.mysql.com/Downloads/Contrib/Win32/SBMySQL50Share.exe Delphi 5 Shareware MySQL Dataset Components.
• http://www.mysql.com/Downloads/Contrib/mysql-ruby-2.2.0.tar.gz MySQL Ruby module. By TOMITA Masahiro tommy@tmtm.org Ruby is an Object-Oriented Interpreter Language (http://www.netlab.co.jp/ruby/).
• http://www.mysql.com/Downloads/Contrib/JdmMysqlDriver-0.1.0.tar.gz A VisualWorks 3.0 Smalltalk driver for MySQL. By joshmiller@earthlink.net.
• http://www.mysql.com/Downloads/Contrib/Db.py Python module with caching. By gandalf@rosmail.com.
• http://www.mysql.com/Downloads/Contrib/MySQLmodule-1.4.tar.gz Python interface for MySQL. By Joseph Skinner joe@earthlight.co.nz. Modified by Joerg Senekowitsch senekow@ibm.net.
• http://www.mysql.com/Downloads/Contrib/MySQL-python-0.3.0.tar.gz MySQLdb Python is an DB-API v2.0-compliant interface to MySQL. Transactions are supported if the server and tables support them. It is thread safe, and contains a compatibility module for older code written for the no-longer-maintained MySQLmodule interface.
• http://www.mysql.com/Downloads/Contrib/mysql_mex_12.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 http://boojum.hut.fi/~kuutela/mysqlmex.html for more information.
• http://www.mysql.com/Downloads/Contrib/mysqltcl-1.53.tar.gz Tcl interface for MySQL. Based on `msqltcl-1.50.tar.gz'. Updated by Tobias Ritzau, tobri@ida.liu.se.
• http://www.mysql.com/Downloads/Contrib/MyC-0.1.tar.gz A Visual Basic-like API, by Ed Carp.
• http://www.mysql.com/Downloads/Contrib/sqlscreens-1.0.1.tar.gz Tcl/Tk code to generate database screens. By Jean-Francois Dockes.
• http://www.mysql.com/Downloads/Contrib/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 making any changes to your applications. By damian@cablenet.net.
• http://www.mysql.com/Downloads/Contrib/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.
• http://www.mysql.com/Downloads/Contrib/pike-mysql-1.4.tar.gz MySQL module for pike. For use with the Roxen web server.
• http://www.mysql.com/Downloads/Contrib/squile.tar.gz Module for guile that allows guile to interact with SQL databases. By Hal Roberts.
• http://www.mysql.com/Downloads/Contrib/stk-mysql.tar.gz Interface for Stk. Stk is the Tk widgets with Scheme underneath instead of Tcl. By Terry Jones.
• http://www.mysql.com/Downloads/Contrib/eiffel-wrapper-1.0.tar.gz Eiffel wrapper by Michael Ravits.
• http://www.mysql.com/Downloads/Contrib/SQLmy0.06.tgz FlagShip Replaceable Database Driver (RDD) for MySQL. By Alejandro Fernandez Herrero. The Flagship RDD homepage is at http://www.fship.com/rdds.html.
• http://www.mysql.com/Downloads/Contrib/mydsn-1.0.zip Binary and source for mydsn.dll. mydsn should be used to build and remove the DSN registry file for the MyODBC driver in Coldfusion applications. By Miguel Angel Solorzano.
• http://www.mysql.com/Downloads/Contrib/MySQL-ADA95_API.zip An ADA95 interface to the MySQL API. By Francois Fabien.
• http://www.mysql.com/Downloads/Contrib/MyTool-DLL_for_VB_and_MySQL.zip A DLL with MySQL C API for Visual Basic. By Ken Menzel kenm@icarz.com.
• http://www.mysql.com/Downloads/Contrib/MYSQLX.EXE MySQL ActiveX Object for directly accessing your MySQL servers from IIS/ASP, VB, VC++ skipping the slower ODBC methods. Fully updatable, multithreaded with full support for all MySQL fieldtypes (version 2001.1.1). By SciBit http://www.scibit.com/.
• http://www.fastflow.it/mylua/ MyLUA home page; how to use the LUA language to write MySQL PROCEDURE that can be loaded runtime.
  • http://www.mysql.com/Downloads/Contrib/lua-4.0.tar.gz LUA 4.0
  • http://www.mysql.com/Downloads/Contrib/mylua-3.23.32.1.tar.gz Patch for MySQL 3.23.32 to use LUA 4.0. By Cristian Giussani.
• http://www.mysql.com/Downloads/Contrib/patched_myodbc.zip Patch (for Omniform 4.0 support) to the MyODBC driver. By Thomas Thaele tthaele@papenmeier.de

B.2 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. 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. GPL 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/mysqlfront.zip MySQL Front, home page: http://www.mysqlfront.de/. Win32-Client for accessing and managing dbs, tables, table-data, indexes, import-/export-files. (Freeware). By Ansgar Becker.
  • 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://dbtools.vila.bol.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/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.
  • 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, peter.kuppelwieser@kantea.it. Updated by Wim Bonis, bonis@kiss.de. 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. TheMyAdmin homepage 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, tobias@dnet.it.
  • http://www.mysql.com/Downloads/Contrib/useradm.tar.gz MySQL administrator in PHP. By Ofni Thomas othomas@vaidsystems.com.
  • http://gossamer-threads.com/perl/mysqlman/mysql.cgi MySQLMan has similar functionality to phpmyadmin, but written with Perl and using html templates. By Alex Krohn.
• 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.

B.3 Web Tools

• 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.

B.4 Performance Benchmarking Tools

• http://www.mysql.com/Downloads/super-smack/super-smack-1.0.tar.gz super-smack is a multi-threaded benchmarking tool for MySQL and PostgreSQL. Written in C++. Easy to extend to support other databases that have C/C++ client libraries. By Sasha Pachev.

B.5 Authentication Tools

• http://www.mysql.com/Downloads/Contrib/ascend-radius-mysql-0.7.2.patch.gz This is an authentication and logging patch using MySQL for Ascend-Radius. By takeshi@SoftAgency.co.jp.
• http://www.mysql.com/Downloads/Contrib/icradius-0.10.tar.gz (icradius 0.10) http://www.mysql.com/Downloads/Contrib/icradius.README (icradius readme)
• http://www.mysql.com/Downloads/Contrib/checkpassword-0.81-mysql-0.6.6.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.
• http://www.mysql.com/Downloads/Contrib/jradius-diff.gz MySQL support for Livingston's Radius 2.01. Authentication and Accounting. By Jose de Leon, jdl@thevision.net.
• http://www.mysql.com/Downloads/Contrib/mod_auth_mysql-2.20.tar.gz Apache authentication module for MySQL. By Zeev Suraski, bourbon@netvision.net.il.
• http://www.mysql.com/Downloads/Contrib/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.
• http://www.mysql.com/Downloads/Contrib/mysql-passwd.README
• http://www.mysql.com/Downloads/Contrib/mysql-passwd-1.2.tar.gz Extra for mod_auth_mysql. This is a two-part system for use with mod_auth_mysql.
• http://www.mysql.com/Downloads/Contrib/pam_mysql.tar.gz This module authenticates users via pam, using MySQL.
• http://www.mysql.com/Downloads/Contrib/nsapi_auth_mysql.tar Netscape Web Server API (NSAPI) functions to authenticate (BASIC) users against MySQL tables. By Yuan John Jiang.
• http://www.mysql.com/Downloads/Contrib/qmail-1.03-mysql-0.6.6.patch.gz Patch for qmail to authenticate users from a MySQL table. By takeshi@SoftAgency.co.jp.
• http://www.mysql.com/Downloads/Contrib/proftpd-1.2.0rc2-fix-mysql.patch Patch for proftpd1.2.0rc2. By takeshi@SoftAgency.co.jp.
• http://www.mysql.com/Downloads/Contrib/pwcheck_mysql-0.1.tar.gz An authentication module for the Cyrus IMAP server. By Aaron Newsome.

B.6 Converters

• 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.pl 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.

B.7 Using MySQL with Other Products

• http://www.mysql.com/Downloads/Contrib/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.
• http://www.mysql.com/Downloads/Win32/myaccess97_1_4.zip (MyAccess97 1.4)
• http://www.mysql.com/Downloads/Win32/myaccess2000_1_4.zip (MyAccess2000 1.4) MyAccess is an AddIn for MS Access 97/2000 that allows you to manage MySQL databases from within Access. Main functions are:
  • Create/Modify Tables
  • Execute Queries against MySQL
  • Extract ''Create Table-Scripts'' from MySQL
  • Import/Export tables from Access to MySQL and vice versa
  • Log Changes
  • Show a "Database Definition Report

Written by Hubertus Hiden. The MyAccess homepage is at http://www.accessmysql.com/.

• http://www.mysql.com/Downloads/Contrib/radius-0.3.tar.gz Patches for radiusd to make it support MySQL. By Wim Bonis, bonis@kiss.de.

B.8 Utilities

• http://worldcommunity.com/opensource/utilities/mysql_backup.html MySQL Backup is a backup script for MySQL. By Peter F. Brown.
• http://www.mysql.com/Downloads/Contrib/mytop
• http://public.yahoo.com/~jzawodn/mytop/ (mytop home page) mytop is a Perl program that allows you to monitor MySQL servers by viewing active threads, queries, and overall server performance numbers. By Jeremy D. Zawodny.
• http://www.mysql.com/Downloads/Contrib/mysql_watchdog.pl Monitor the MySQL daemon for possible lockups. By Yermo Lamers, yml@yml.com.
• http://www.mysql.com/Downloads/Contrib/mysqltop.tar.gz Sends a query in a fixed time interval to the server and shows the resulting table. By Thomas Wana.
• http://www.mysql.com/Downloads/Contrib/mysql_structure_dumper.tar.gz
• http://www.mysql.com/Downloads/Contrib/mysql_structure_dumper.tgz Prints the structure of every table in a database. By Thomas Wana.
• http://www.mysql.com/Downloads/Contrib/mysqlsync. A Perl script to keep remote copies of a MySQL database in sync with a central master copy. By Mark Jeftovic. markjr@easydns.com.
• http://www.mysql.com/Downloads/Contrib/MySQLTutor-0.2.tar.gz. MySQLTutor. A MySQL tutorial for beginners.
• http://www.mysql.com/Downloads/Contrib/MySQLDB.zip
• http://www.mysql.com/Downloads/Contrib/MySQLDB-readme.html. A COM library for MySQL by Alok Singh.
• http://www.mysql.com/Downloads/Contrib/mysql_replicate.pl Perl program that handles replication. By elble@icculus.nsg.nwu.edu
• http://www.mysql.com/Downloads/Contrib/DBIx-TextIndex-0.02.tar.gz Perl script that uses reverse indexing to handle text searching. By Daniel Koch.
• http://www.mysql.com/Downloads/Contrib/dbcheck Perl script that takes a backup of tables before running isamchk on them. By Elizabeth.
• http://www.mysql.com/Downloads/Contrib/mybackup.
• http://www.mswanson.com/mybackup (mybackup home page) Wrapper for mysqldump to backup all databases. By Marc Swanson.
• http://www.mysql.com/Downloads/Contrib/mdu.pl.gz Prints the storage usage of a MySQL database.

B.9 RPMs for Common Tools (Most Are for RedHat 6.1)

• http://www.mysql.com/Downloads/Contrib/perl-Data-ShowTable-3.3-2.i386.rpm
• http://www.mysql.com/Downloads/Contrib/perl-Msql-Mysql-modules-1.2210-2.i386.rpm
• http://www.mysql.com/Downloads/Contrib/php-pg-3.0.13-1.i386.rpm
• http://www.mysql.com/Downloads/Contrib/php-pg-manual-3.0.13-1.i386.rpm
• http://www.mysql.com/Downloads/Contrib/php-pg-mysql-3.0.13-1.i386.rpm
• http://www.mysql.com/Downloads/Contrib/phpMyAdmin-2.0.5-1.noarch.rpm

B.10 Useful Functions

• http://www.mysql.com/Downloads/Contrib/mysnprintf.c sprintf() function for SQL queries that can escape blobs. By Chunhua Liu.

B.11 Windows Programs

• http://www.mysql.com/Downloads/Contrib/LaunchMySQL.zip The program launches the MySQL server, shuts it down, and display status information. By Bill Thompson

B.12 Uncategorised

• http://www.mysql.com/Downloads/Contrib/findres.pl Find reserved words in tables. By Nem W Schlecht.
• http://www.mysql.com/Downloads/Contrib/handicap.tar.gz Performance handicapping system for yachts. Uses PHP. By rhill@stobyn.ml.org.
• http://www.mysql.com/Downloads/Contrib/hylalog-1.0.tar.gz Store hylafax outgoing faxes in a MySQL database. By Sinisa Milivojevic, sinisa@mysql.com.
• http://www.mysql.com/Downloads/Contrib/mrtg-mysql-1.0.tar.gz MySQL status plotting with MRTG, by Luuk de Boer, luuk@wxs.nl.
• http://www.mysql.com/Downloads/Contrib/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.
• http://www.mysql.com/Downloads/Contrib/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.
• http://www.mysql.com/Downloads/Contrib/Old-Versions Previous versions of things found here that you probably won't be interested in.