Most databases have two different components such as back end and front end. Back end is where the data is kept and front end comprise of a user interface for communication. This type of design opens the way for third parties to build rich applications to interface database.
In this article i am dealing with some MySql GUI tools.
1. Workbench
MySQL workbench is a database design platform that incorporates development of SQL, administration, building and maintenance into a development environment. It is developed by Sun Systems. Supported operating systems include Microsoft windows, Mac OS X and Linux. It’s earlier version was 5.0 and the current version is 5.2. It developed after DBDesigner4.
2. Sequel Pro
It is a free tool developed by Sequel Pro Project. It is an easy tool used to manage MySQL database over th world wide web and also locally. It provides many facilities like addition and removal of tables and databases, addition and removal of rows etc. It can also deal with some custom queries and can view and manage table content.
3. PhpMyAdmin
It is a free developer’s tool based on PHP which is aimed to handle MySQL over the web. This tool supports a large number of operations with MySQL. They can be used to manage databases, tables, fields, indexes etc.
4. SQLWave
It is a MySQL graphical user interface tool developed to simplify and automate thr development process of database. It can be also used to maintain and explore databases. It also manipulates and query information in various ways.
5. DBTools manager
It is an efficient tool which is available in two editions. One is a Standard edition and other is a Enterprise edition. Standard edition is aimed for the personal use and it does not have full set of features. Enterprise edition comes with all features and also has a trial period. They are developed by DBTools software.
3 Responses So Far:
No SQL buddy?
SqlYog
Have you tried dbForge Studio for MySQL?