MysqlTool

Important Note | Introduction | Features | Documentation | Download

Important Note

MysqlTool was written by Abraham Ingersoll, Joseph Ingersoll and others of Dajoba, LLC. I had no involvement in its development other than suggestions and bug reports. I am providing it on this web site as the Dajoba web site is apparently no longer available.

MysqlTool is provided on an AS-IS basis with NO WARRANTY and NO SUPPORT.

If you have trouble with MysqlTool, PLEASE DO NOT EMAIL ME ABOUT IT. I do NOT have the answers to your problems.

Introduction

MysqlTool provides a web interface for managing one or more MySQL server installations. Designed as a graphical alternative to the mysql command line program, 'the tool' supports most administration functions such as 'GRANT', 'REVOKE', 'CREATE', 'ALTER' & 'SHOW'. Written entirely in perl, MysqlTool runs best under the Apache HTTP Server with mod_perl, but should work just as well as a CGI on any perl-supported platform. MysqlTool is licensed under the GPL. Version, 0.95 was the eighth public release.

MysqlTool is believed to be no longer under active development.

Features

• management of multiple servers
• tree view of database schema in an independant frame
• display of server status variables
• display of server processes/threads
• killing server processes/threads
• management of server scope privileges
• creating and dropping databases
• creating, altering and dropping tables
• management of database scope privileges
• creating, altering and dropping fields
• creating and dropping indexes
• management of table scope privileges
• management of column scope privileges
• SQL Execution interface with results
• browse database records
• adding records to tables
• editing records from a SQL execution result set
• deleting records from a SQL execution result set
• generation of "CREATE TABLE" text file for any database

Documentation

MysqlTool documentation is provided in perldoc format. After installing MysqlTool, run "perldoc mysqltool" to view.

Download

MysqlTool is made available under the terms of the Free Software Foundation's General Public License, Version 2.

Source code: MysqlTool-0.95.tar.gz ( 44K)