Go to Home Page GuidesHow to ArticlesReviewsForumsFrequently Asked QuestionsNewsLinksPotpourri

Site Search


Open Source/Free Graphical Management Utilities for the MySQL Database Server
Last updated: 5/18/2003

phpMyAdmin (2.5.0) Features

"phpMyAdmin can manage a whole MySQL server (needs a super-user) as well as a single database. To accomplish the latter you'll need a properly set up MySQL user who can read/write only the desired database. It's up to you to look up the appropriate part in the MySQL manual. Currently phpMyAdmin can:

  • create and drop databases
  • create, copy, drop, rename and alter tables
  • do table maintenance
  • delete, edit and add fields
  • execute any SQL-statement, even batch-queries
  • manage keys on fields
  • load text files into tables
  • create (*) and read dumps of tables
  • export (*) data to CSV, XML and Latex formats
  • administer multiple servers
  • manage MySQL users and privileges
  • check referential integrity
  • using Query-by-example (QBE), create complex queries automatically connecting required tables
  • create PDF graphics of your Database layout
  • search globally in a database or a subset of it
  • transform stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link or ...
  • communicate in 42 different languages."

There is a long list of improvements for version 2.5.0 on the phpMyAdmin web site.

MYSQL Front (2.5) Features

"With MySQL-Front you can...
- create/drop databases
- create/drop tables
- edit/add/delete fields
- edit/insert/delete records
- edit BLOBs with Bitmap/GIF/JPEG-Support
- a list of server-variables
- view and kill other user-processes
- execute (large) SQL-scripts
- view advanced table-properties, such as Type, Comment, Key_Length
and so on
- export table-structure and data into SQL-scripts or other databases
- replicate databases between two hosts ("Export tables...")
- save data to CSV-Files (ideal for working with MS-Excel) or
- copy CSV-data/HTML-Tables to clipboard
- copy tables to new table-names
- change table-types to ISAM, MYISAM, MERGE, HEAP, InnoDB, BDB or
userdefined types
- manage users (New in 2.0: edit existing users!)
- flush Host/Logs/Privileges/Tables
- write SQL-queries with syntax-highlighting
- import data from ODBC-datasources
- do table-diagnostics (check, optimize, repair, analyze)
- insert files into BLOBs in batch-mode
- and a lot more... "

freeMascon (2001.2.3.26) Features

There are screen-shots of the full version and a list of features for the free and full versions on SciBit's web site.

MySQL Control Center (0.9.2-beta) Features

"Interactive queries with a syntax-highlighting SQL editor
With MySQLCC, you can construct queries using a syntax-highlighting text editor, and then view the results in a configurable table display. The table view includes support for viewing images stored in BLOB fields.

Database and table management
MySQLCC makes it easy to create and manage databases and tables, including views for all of the table and field attributes such as comments and key lengths. You can also check, repair, and optimize tables.

Server administration
You can easily view and change server variables, as well as view server status information. MySQLCC also supports multiple servers.

MySQLCC uses Trolltech's Qt toolkit, which means it can run on Microsoft Windows and Unix environments, and we plan on support Mac OS X in future versions."

SQLyog (3.11) Features

  • "very fast retrieval of data
  • ODBC Import with option to import data through query
  • database synchronization tool
  • update result returned from query
  • manage foreign relationships
  • fully InnoDB compliant
  • view your results in GRID / TEXT mode
  • fast client side sorting and filtering
  • execute ( very large ) SQL-scripts as batch files
  • execute multiple queries returning more than 1000s of rows per resultset. Its very efficient in memory
  • very compact binary ( 520KB Installer )
  • written entirely in C/C++/Win32 APIs using native MySQL C APIs. No wrapper classes used
  • connection manager
  • excel like grid interface to create/alter tables
  • excel like grid interface to edit data with support for Enum/Set
  • create/drop databases
  • manage indexes
  • comprehensive security manager. Control access to databases/tables/columns
  • reorder columns of table
  • copy database/tables between two MySQL hosts
  • drop all tables of a database with a single click
  • edit BLOBs with Bitmap/GIF/JPEG-Support
  • export table-structure and data into SQL-scripts
  • export/import data in/from CSV files
  • export database schema in HTML
  • log all queries for a session
  • profile queries
  • syntax-highlighting
  • save resultset in CSV, HTML and XML
  • save your commonly used SQL scripts in a personal folder with a click of mouse
  • is very keyboard friendly. You can work with 99% features of SQLyog with keyboard.
  • view and kill other user-processes
  • view advanced table-properties, such as Type, Comment, Key_Length and so on
  • a list of server-variables e.g processlist, status, variables etc
  • copy your result as CSV in clipboard
  • copy tables to new table-names
  • change table-types to ISAM, MYISAM, MERGE, HEAP, InnoDB, BDB
  • flush Host/Logs/Privileges/Tables
  • do table-diagnostics (check, optimize, repair, analyze)
  • FREE!
  • and a lot more..."

< Back to Page 1

Copyright, Disclaimer, and Trademark Information Copyright © 1996-2006 Larry F. Byard.  All rights reserved. This material or parts thereof may not be copied, published, put on the Internet, rewritten, or redistributed without explicit, written permission from the author.