
It can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage users and permissions, and manage keys on fields.
This very popular, feature rich and easy to use free tool, written in PHP (obviusly), has been built to handle the full administration of MySQL. Download Aqua Data Studio Downloads Page.
Help and Support Aqua Data Studio Support. The Studio has a single consistent interface to all major relational databases, this allows the developer to simultaneously tackle several tasks from within a single application. This complete IDE, has four major areas of functionality: Database query and administration tools a suite of compare tools for databases, source control and file systems integrated source control client for Subversion (SVN) and CVS and a powerful database modeler. jHeidi Mobi Download Page Aqua Data Studio (Win, Linux, OS X, Solaris) You can also download a small app for the iPhone called jHeidi Mobi, whicht is the only application to offer Oracle and MySQL access in a mobile application.
Heidi SQL is lightweight and fast with a flexible interface, it allows you to browse and edit your databases databases, manage tables, view and edit records, manage user-privileges, import data from text files, run SQL queries, synchronize tables between two databases and export selected tables to other databases or SQL scripts, and all this from an intuitive Windows interface. If you feel adventurous you could always go for the commercial version (Standard Edition). The free version is the Community Edition, which is loaded with features that will meet almost all your requirements. This application is a fully featured visual database design package that includes database design, modeling, creation and maintenance bundled into a single environment for the MySQL database system.
Cheat Sheet Round-Up: Ajax, CSS, MySQL, Ruby…. You may be interested in the following related posts: Please let us know if some useful MySQL-tool is missing in the list by commenting upon this article. Among other tools we feature phpMyAdmin, MySQL Workbench, HeidiSQL and SequelPro. In the overview below we present some of the most useful and most popular MySQL Admin and Development Tools for Mac, Windows and Linux, for beginners and for professionals. The question now is which is the best MySQL Admin and Development Tool. So, MySQL is the best database, and we all use it. One of MySQLs main features is its cross-platform support, it will run on almost all operating systems, including Windows, OSX, Linux and many more. It is consistently fast, reliabile and very, very easy to use. The most popular and best open source database is MySQL.