Top 10 MySQL Database Manager Tools (Open Source)

Wikipedia : "MySQL is an open source database management system. It's a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack—LAMP is an acronym for "Linux, Apache, MySQL, Perl/PHP/Python".

As we know, MySQL was used in many CMS (Content Management System) includes eCommerce sites based, blogging platforms, and other web applications.

I think, as a part of data-based management system, build a strong database is very important especially regarding public service. I am sure, you as a developer of course be aware of this.

To facilitate you in writing as well as controlling your database, below are some MySQL database managers that might suit to your needs.

Here are :

1. MySQL Workbench : MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, and much more. MySQL Workbench is available on Windows, Linux and Mac OS.

2. phpMyAdmin : phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin 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).

3. DBEdit 2 : DBEdit 2 is a database editor, suitable as front-end for all your relational databases. Connects to Oracle, DB2, MySQL and many other databases. Used to easily query, update and administer your database, create reports and synchronize data. Supports Oracle, DB2, MySQL, SQLite, HSQLDB, H2, Apache Derby and SQL Server. Runs on Windows, Linux, Solaris and Mac OS X.

4. Adminer : Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL and Oracle. Supports both PHP 4.3.3+ and PHP 5 with enabled sessions.

5. HeidiSQL : HeidiSQL is a lightweight, Windows based interface for managing MySQL and Microsoft SQL databases. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data either to SQL file, clipboard or to other servers.

6. Eclipse SQL Explorer : Eclipse SQL Explorer is a thin SQL client that allows you to query and browse any JDBC compliant database. It supports plugins with specialized functionality for individual databases (Oracle, DB2 and MySQL) and can be extended to include specialized support for other databases.

7. DB Designer Fork : DB Designer Fork is a fork of the fabFORCE DBDesigner 4. It integrates entity relationship design,front-end (you can run queries) and SQL exporting.DB Designer Fork generates SQL scripts for Oracle, SQL Server, MySQL, FireBird, SQLite and PostgreSQL.

8. SQuirreL SQL Client : SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

9. WWW SQL Designer : WWW SQL Designer allows users to create database designs, which can be saved/loaded and exported to SQL scripts. Various databases and languages are supported. Ability to import existing database design.

10. DBDesigner 4 : DBDesigner 4 is a visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment.


How do you think?

Glad to hear your opinion. Please if you have another opinion. Thank you.

Happy freelancing, keep working, keep your health, and good luck for all! :)

Courtesy: http://onlinejobspedia.blogspot.com/2012/03/top-10-mysql-database-manager-tools.html