Mysql Database Server
Web interface or GUI Tools
The main purpose of these tools is easy to maintain
Mysql
server
phpmyadmin
phpMyAdmin is a tool written in PHP intended to handle the
administration of MySQL over the Web. It can create, rename, and
drop databases, create/drop/alter tables, delete/edit/add
fields, execute any SQL statement, manage keys on fields, create
dumps of tables and databases, export/import CSV data and
administrate one single database and multiple MySQL servers.
Downloads and Documentation
http://www.phpmyadmin.net/
MySQL Users
MySQL Users provides a simple Web-based interface for creating
new MySQL users and maintaining existing ones.
Downloads and Documentation
http://www.itlab.musc.edu/mysql_users/mysql_users_readme.html
MyClient
MyClient is a simple and clean Web client interface for the
MySQL database. It runs with PHP's register_globals off and
outputs validated XHTML and CSS. Features include unlimited
multiple tabbed interfaces, connection to multiple databases,
one-button table descriptions, one-button database switching,
query saving and loading, query results saving, and
localization. It is not a full featured administration tool, but
rather a multiple interface command client that improves upon
the command line interface using a Web-based implementation.
Downloads and Documentation
http://myclient.polarlava.com/
WebMySQL
WebMySQL is a Web interface to a MySQL database server. It
supports the following SQL queries: SELECT, DESCRIBE, JOIN,
SHOW, DROP, CREATE, and USE, and advanced query options such as
LIMIT, DISTINCT, and GROUP. Empty databases and tables and
mysqldump file imports and exports are supported. It has a fully
customisable look and feel, and outputs either HTML results or a
downloadable CSV file.
Downloads and Documentation
http://www.thedumbterminal.co.uk/software/webmysql.shtml
MySQL
Administrator
MySQL Administrator is a powerful visual administration console
that enables you to easily administer your MySQL environment and
gain significantly better visibility into how your databases are
operating. MySQL Administrator now integrates database
management and maintenance into a single, seamless environment,
with a clear and intuitive graphical user interface. By using
MySQL Administrator you will be able to:
Achieve higher database availability through improved management
Reduce errors through visual database administration
Lower database administration costs through improved
productivity
Deliver a more secure environment through easier privilege
management
Downloads
http://dev.mysql.com/downloads/administrator/1.1.html
Documentation
http://dev.mysql.com/doc/administrator/en/index.html
MySQL Query Browser
MySQL Query Browser is the easiest visual tool for creating,
executing, and optimizing SQL queries for your MySQL Database
Server. The MySQL Query Browser gives you a complete set of
drag-and-drop tools to visually build, analyze and manage your
queries. Plus, the integrated environment provides:
Query Toolbar to easily create and execute queries and navigate
query history
Script Editor giving you control to manually create or edit SQL
statements
Results Window so you can also easily compare and work with
multiple queries
Object Browser enabling you to manage your databases, bookmarks,
and history using a Web Browser like interface
Database Explorer where you can select tables and fields to
query, as well as create and delete tables
Table Editor allows you easily create, modify and delete tables
Inline Help giving you instant help access to selected objects,
parameters, and functions
Downloads
http://dev.mysql.com/downloads/query-browser/1.1.html
Documentation
http://dev.mysql.com/doc/query-browser/en/
Gnome Mysql Client
Gmyclient is designed to be a simple, quick, and powerful way to
access your MySQL database. It provides you with a simple way to
change or create database data. It makes using MySQL very easy.
Downloads and Documentation
http://gmyclient.sourceforge.net/
