W3Avenue

Whether you are developing desktop software or web based application, there is a pretty good chance you will consider MySQL for data storage. Due to its popularity and open source business model, numerous tools and utilities are available that will help you easily design and manage your MySQL databases.

W3Avenue has compiled a list of really useful free tools and utilities for MySQL that will enable you design and manage your databases of various scope and complexity.

Cross Platform

• MySQL GUI Tools
  The MySQL GUI Tools is a set of cross platform tools that include: MySQL Administrator, MySQL Query Browser and MySQL Migration Toolkit.
• MySQL Workbench
  MySQL Workbench is a cross platform GUI product for the MySQL Server that can be used to write and execute SQL queries and scripts, edit data, visually design database models and manage the MySQL Server.
• MySQL Control Center
  MySQL Control Center is a GUI front end for MySQL database creation and administration. It allows multiple concurrent MySQL server connections, MDI, stored login credentials, point and click dump file imports and more.
• SQuirreL SQL
  SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

Mac OS X

• Sequel Pro
  Sequel Pro is fast, easy to use Mac OS X database management application for working with MySQL databases. It gives you direct access to your MySQL databases on local and remote servers.
• YourSQL
  YourSQL is intended to be easy to use for the beginner as well as the advanced user. It provides access to advanced features of MySQL, such as indices, InnoDB tables, multi-statement SQL scripts and multi-threaded handling of SQL dumps for backups or similar administration tasks.

Windows

• HeidiSQL
  HeidiSQL is an easy to use MySQL management client for Windows. It allows you to synchronize tables between two databases; manage user-privileges; import / export; browse and edit table-data using a comfortable grid; create and edit stored procedures; and lot more. You can also run HeidiSQL on Linux with Wine.
• Toad for MySQL
  Toad for MySQL is database development and administration tool that enables: query development, database design, database administration, data management, reporting, project management and automation.
• MyDB Studio
  MyDB Studio is a collection of powerful tools for MySQL Server administration. It also supports SSH tunneling to secure your connections enabling you to connect even if your host doesn’t allow you remote access connection.

Web Based

• phpMyAdmin
  phpMyAdmin is one of the most popular web based MySQL administration tool written in PHP. It supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.
• MySQL Sidu
  Sidu (Select, Insert, Delete, Update) is a web based MySQL client with easy to use GUI. In addition to standard MySQL administration you can use Sidu to sorts data in two columns; secures your data with multiple firewalls; manage accesses easily; filter and sort tables to export.
• VFront
  VFront is a dynamic front-end for MySQL or PostgreSQL databases written in PHP and Javascript. With VFront you can create forms for manage your data in AJAX style, different rules and privileges for groups, report in XML,HTML,PDF,statistics and much more.
• SQL Buddy
  SQL Buddy is an open source web based MySQL administration tool developed using PHP. Just unzip the files to your server and its ready to use. Logins are handled directly by MySQL, and you can create as many or as few users as you want.
• MySQL Ajax Table Editor
  This is a free open source application (PHP4 & PHP5 compatible) that allows you to quickly create database admin pages and manage MySQL tables. Its MySQL editor has the ability to join on multiple tables and maintain search functionality and is written with AJAX.
• Adminer
  Adminer is a full-featured MySQL management tool written in PHP. It consist of only a single file ready to deploy to the target server. Supports both PHP 4.3+ and PHP 5 with sessions enabled.
• MySql Lite Administrator
  MySql Lite Administrator is a PHP based web application that will help you insert and update data in your MySQL Database.
• AeroSQL
  AeroSQL is an open source web based tool for managing MySql. The key feature of AeroSQL is intuitive management of the database content.
• MySQLDumper
  MySQLDumper is a PHP and Perl based tool for backing up MySQL databases. You can easily dump your data into a backup file and – if needed – restore it. It is especially suited for shared web hosting, where you don’t have shell access.
• phpMyBackupPro
  phpMyBackup Pro is a very easy to use, PHP based MySQL backup application. It allows you to create schedule, manage, restore, download or email database backups.
• WWW SQL Designer
  WWW SQL Designer is a web based visual SQL modeling tool that allows you to draw E-R designs, edit tables and rows, manage keys, create relations (FK constraints), save & load designs and import DB schemas.

Cheet Sheets

• Added Bytes: MySQL Cheat Sheet
• Tech-Geeks: Handy Cheat Sheet of MySQL Commands
• MySQL SQL Injection Cheat Sheet
• Pantz: MySQL Commands
• Tech-Evangelist: MySQL Cheat Sheet by Example

Please feel free to suggest any addition, correction or updates in your comments. You may also be interested in reading following posts published on W3Avenue:

• Really Useful Tools For PHP Developers
• Really Useful Classes And Libraries For PHP Developers