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.
- 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 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.
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.
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.
- 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 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 is an open source web based tool for managing MySql. The key feature of AeroSQL is intuitive management of the database content.
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.
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.
- 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: