most relational databases are obviously different from MS Access. They have two distinct parts: the backend serves as the data warehouse and the front end serves as the user interface for data component communication. This design is very ingenious. It processes two-layer programming models in parallel, separating the data layer from the user interface. At the same time, database software manufacturers focus on their product strengths: Data storage and management. At the same time, it facilitates the third party to create a large number of applications and makes the interaction between various databases stronger. Such products include Embarcadero Rapid SQL and Oracle SQL Developer. Here are ten excellent MySQL graphical interfaces.
manufacturer: Sun Systems/Oracle website: http://dev.mysql.com/downloads/workbench/ Price: free License: GPL License support platform: Microsoft Windows,Mac OS X,Linux
MySQL Workbench is a graphical database design tool that integrates SQL development, management, database design, creation, and maintenance in a development environment. It is the successor of fabFORCE.net's DBDesigner 4 and has replaced MySQL GUI Tools Bundle. The current version is 5.2, and the earliest version is 5.0. This is to emphasize the fact that MySQL Workbench was developed as the successor of dbdesigner4.
manufacturer: PremiumSoft™CyberTech Ltd. website: http://www.navicat.com/en/products/navicat_mysql/mysql_overview.html价格:如下所示:
with a 30 day trial. licenses: Commercial or Non-commercial licenses. Supported Platforms: Microsoft Windows,Mac OS X, and Linux
the Navicat used for MySQL is both a database manager and a development tool. It is applicable to any MySQL database server that runs from over 3.21, and supports most of the latest MySQL functions, including triggers, stored procedures, functions, events, preview, and user management.
Navicat features are complex enough to meet the special needs of professional developers. It is also easy for beginners in MySQL to learn.
3. Sequel Pro
manufacturer: The Sequel Pro Project (open source) website: http://www.sequelpro.com/Price: Free (accept donations through PayPal) license: GNU GPL 2.0 support platform: Mac OS X Tiger Universal Build
Sequel Pro is a free open source program. It is the successor of CocoaMySQL Mac database management program. CocoaMySQL is a new idea of Lorenz Textor. He was the early main developer of CocoaMySQL (2003).
Sequel Pro is used to manage MySQL databases (locally or on Internet). You can use it to add and delete databases and tables, modify fields and indexes, preview and filter table content, add, edit and delete rows, execute custom queries, dump tables or the entire database.
It is compatible with MySQL 3.x, 4, and 5.
manufacturer: Ansgar Becker website: http://www.heidisql.com/Price: Free (accept donations through PayPal) License: GNU General Public License support platform: Windows 2000,XP,Vista,7 (can be run on any Linux through Wine)
mySQL-Front, formerly known as HeidiSQL, is a free open source client developed by German programmers Ansgar Becker, and also has the help of some Delphi contributors. You must create a session to log on to a local or remote MySQL server through a license before you can use HeidiSQL to manage databases. Through this session, you can manage the MySQL database of the connected MySQL server and disconnect it after completion. Its feature set is sufficient to handle most common and advanced database, table, and data recording options. However, it is still under active development to implement all the front-end functions of MySQL.
There is also a jHeidi written in Java, which is designed for Mac and Linux computers. Unfortunately, the project ended in March 2010.
manufacturer: The phpMyAdmin Project (on Sourceforge) website: http://www.phpmyadmin.net/home_page/ Price: Free (accept donations through PayPal) License: GNU General Public License, version 2 support platform: Microsoft Windows,Mac OS X,Linux,PHP 4 - 5,MySQL 3 - 5
PhpMyAdmin is a free software tool written in PHP for online MySQL management. PhpMyAdmin supports multiple MySQL operations. The most common operations include managing databases, tables, fields, relationships, indexes, users, and permissions. You can also directly execute SQL statements.
Tobias Ratschiller used to be an IT consultant and later founded Maguma software company. Affected by the Peter Kuppelwieser of MySQL-Webadmin development, the PHP-based MySQL web front-end development began in 1998. Due to lack of time, he gave up the project in 2000 (and he also developed phpAdsNew). At that time, phpMyAdmin has become one of the most popular PHP programs and MySQL management tools, with a wide range of community users and contributors. In order to coordinate more and more patches, three developers Olivier M ü ller,Marc Delisle and Lo c Chapeaux registered the phpMyAdmin project in SourceForge.net and took over the development work in 2001.
6. SQL Maestro MySQL Tools Family
manufacturer: SQL Maestro Group website: http://www.sqlmaestro.com/products/mysql/ Price: range from $99 non-commercial program to $1949 MySQL Admin Tools Bundle, including complete website business license plus 3-year upgrade. The bundle includes SQL Maestro,Data Wizard,Code Factory,Service Center, and PHP Generator Pro. License: fully support from independent non-commercial to site business license supporting platforms with 3-year free upgrade: Windows 2000,XP,Vista,7
SQL Maestro Group provides a complete database management, development and management tool for all mainstream DBMS. On the GUI, you can run queries and SQL scripts to manage users and their privileges, import, export, and back up data. In addition, you can generate PHP scripts for the selected tables and queries, and transfer any ADO compatible databases to MySQL databases.
The bundle includes:
SQL Maestro for MySQL professional MySQL GUI management tool that supports all the latest MySQL 5.0 and 5.1. Features include preview, process, trigger, and table partition.
Data Wizard for MySQL MySQL dumps and Data export/import tools.
Code Factory for MySQL visual tool set for editing SQL scripts and creating SQL statements.
Service Center for MySQL is used for MySQL server maintenance.
PHP Generator for MySQL generate high-performance MySQL PHP scripts. The free version is available.
manufacturer: Nerocode website: http://www.nerocode.com/price:$99.00 license: shareware. See http://www.nerocode.com/license.txt以获得更多相关信息 。 Supported platforms: Windows 2000,XP,Vista,7
Nerocode SQLWave is a MySQL GUI client tool designed to automate and simplify the database development process. It also provides a simpler way to develop and maintain existing databases, as well as different ways to design complex SQL statements, queries, and data operations. Compatible with MySQL 4.x- 6.x.
With a 30 day trial.
8. dbForge Studio
manufacturer: devart website: http://www.devart.com/dbforge/mysql/studio/ Price: free Express edition,$49.95 (non-commercial standard edition),$99.99 (non-commercial Professional Edition). Licenses: commercial and non-commercial licenses. Provides subscription as an efficient and fast way to achieve product upgrades and technical support. Supported platforms: Windows 2000,XP,Vista,7
DbForge Studio for MySQL provides graphical MySQL development and management.
There are three versions: Express,Standard, and Professional.
Express is a free application that provides basic functions for architecture objects, user accounts, SQL scripts, and queries.
Standard provides database administrators and developers with additional tools, such as debugger,Query Builder, code templates, object retrieval, and various output and maintenance Wizards.
Professional is a full-featured version with the following design added: database project, which accurately compares and synchronizes database structure (architecture comparison) or database content (data comparison), debug stored procedures and scripts to create complex queries.
Other tools dbForge include:
Schema Compare for MySQL
Data Compare for MySQL
Query Builder for MySQL
Fusion for MySQL
9. DBTools Manager
manufacturer: DBTools Software website: http://www.dbtools.com.br/EN/dbmanagerpro/ Price: standard edition free. A single-authorized Enterprise Edition costs USD 69.90. The Discounts edition applies to the license. License: The standard edition is licensed to standard free software conditions. The Enterprise Edition is authorized to the sales unit. Supported platforms: Windows 2000,XP,Vista,7
the standard edition is specially designed for personal use. It is equipped with minimum functions and is suitable for beginners to perform basic database management. You can use it for free on non-commercial premises. For commercial use, you can purchase authorization and provide additional functions.
The Enterprise Edition is specially designed for enterprises. It is more suitable for DBA and developers who are looking for integrated database management programs. You can try it out before purchasing. The trial version of the Enterprise Edition is full-featured. You have 20 days to try all of them and decide whether to buy them based on the complete experience.
MySQL 3,4, and 5 are supported.
10. MyDB Studio
manufacturer: H2LSoft, Inc. Website: http://www.mydb-studio.com/Price: free authorization: Free software support platform: Windows 2000,XP,Vista,7
MyDB Studio contains a complete set of tools for MySQL server management. It can be used to create/edit/discard database objects, synchronize databases, and export/import data. Database administrators can also use it to perform database transfer, backup and restore. It supports using SSH tunnels to protect your links. Even if your host does not allow remote access to links, user and permission management, and PHP script creation, you can still connect. -------------------------
view original text: Top 10 MySQL GUI Tools
Start Building Today with a Free Trial to 50+ Products
Learn and experience the power of Alibaba Cloud.Sign Up Now