Shulou(Shulou.com)05/31 Report--

This article mainly introduces what MySQL GUI tools have, have a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

1. Workbench

Manufacturer: Sun Systems/Oracle

Website: http://dev.mysql.com/downloads/workbench/

Price: free of charge

License: GPL License

Supporting platform: Microsoft Windows,Mac OS XJ 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 to fabFORCE.net 's DBDesigner 4 and replaces MySQL GUI Tools Bundle. The current version is 5. 2, with the earliest version 5. 0, to emphasize the fact that MySQL Workbench was developed as a successor to DBDesigner4.

2. Navicat

Manufacturer: PremiumSoft ™CyberTech Ltd.

Website: http://www.navicat.com/en/products/navicat_mysql/mysql_overview.html

Price: as follows:

Windows Edition (Non-Commercial) US $209 (disk)

US $199 (download)

Windows EditionUS $379 (disk)

US $369 (download)

Mac OS X Edition (Non-Commercial) US $209 (disk)

US $199 (download)

Mac OS X EditionUS $329 (disk)

US $319 (download)

Linux Edition (Non-Commercial) US $189 (disk)

US $179 (download)

Linux EditionUS $329 (disk)

US $319 (download)

Equipped with a 30-day trial version.

License: Commercial or Non-commercial licenses.

Supporting platform: Microsoft Windows,Mac OS XJ Linux

Navicat for MySQL is both a database manager and a development tool. It is suitable for any MySQL database server from 3.21 or above, and supports most of the latest MySQL features, including triggers, stored procedures, functions, events, previews and user management.

The functions of Navicat are complex enough to meet the special needs of professional developers, and it is also very easy for beginners of 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

Supporting platform: Mac OS X Tiger Universal Build

Sequel Pro is a free open source program. It is the successor to the CocoaMySQL Mac database manager. CocoaMySQL is the new idea of Lorenz Textor, who was the main developer of CocoaMySQL in its early days (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 the contents of tables, add, edit and delete rows, execute custom queries, dump tables, or entire databases.

It is compatible with MySQL 3.x, 4, and 5.

4. HeidiSQL

Manufacturer: Ansgar Becker

Website: http://www.heidisql.com/

Price: free (accept donations through PayPal)

License: GNU General Public License

Supporting platform: Windows 2000 XP Magi Vista 7 (can be run on any Linux via Wine)

HeidiSQL, formerly known as MySQL-Front, is a free open source client developed by German programmer Ansgar Becker with the help of some Delphi contributors. Users must log in to a local or remote MySQL server with a license to create a session before they can use HeidiSQL to manage the database. Through this session, the user can manage the MySQL database of the linked MySQL server and disconnect after completion. Its feature set is adequate for most common and advanced database, table, and data logging options, but it is still under active development to achieve all the functions of the MySQL front end.

There is also a jHeidi written by Java, which is designed for Mac and Linux computers. Unfortunately, the project was terminated in March 2010.

5. PhpMyAdmin

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

Supported platform: Microsoft Windows,Mac OS XMagi LinuxPHP 4-5 MySQL 3-5

PhpMyAdmin is a free software tool written in PHP for online processing of MySQL management. PhpMyAdmin supports a variety of MySQL operations, including managing databases, tables, fields, relationships, indexes, users, and permissions. It also allows you to execute SQL statements directly.

Tobias Ratschiller used to be a consultant for IT and later founded Maguma Software. Due to the influence of MySQL-Webadmin developed by Peter Kuppelwieser, web front-end development based on PHP MySQL was started in 1998. Due to lack of time, he abandoned the project in 2000 (as well as phpAdsNew, which he developed). At that time, phpMyAdmin had 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 with the registered 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 for non-commercial programs to $1949 for MySQL Admin Tools Bundle, including a full website business license plus a 3-year upgrade. SQL Maestro,Data Wizard,Code Factory,Service Center and PHP Generator Pro are included in the bundle.

License: full range of support from separate non-commercial to site commercial licenses with 3-year free upgrades

Supporting platform: Windows 2000, XP, Vista, 7

SQL Maestro Group provides a complete database management, development and management tools for all major DBMS. Through the GUI interface, you can execute queries and SQL scripts, manage users and their privileges, import, export everywhere, and data backup. At the same time, you can generate PHP scripts for selected tables and queries, and transfer any ADO-compliant database to the MySQL database.

The bundle includes:

SQL Maestro for MySQL

Professional MySQL GUI management tools that support all the latest MySQL 5.0,5.1. Features include previews, procedures, triggers and table partitions.

Data Wizard for MySQL

MySQL dump, and data export / import tools, etc.

Code Factory for MySQL

A visual toolset for editing SQL scripts and creating SQL statements.

Service Center for MySQL

Used for MySQL server maintenance.

PHP Generator for MySQL

Generate high-performance MySQL PHP scripts. Comes with a free version.

7. SQLWave

Manufacturer: Nerocode

Website: http://www.nerocode.com/

Price: $99.00

License: shareware. Check http://www.nerocode.com/license.txt for more information.

Supporting platform: 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 easier ways 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.

Equipped with a 30-day trial version.

8. DbForge Studio

Manufacturer: devart

Website: http://www.devart.com/dbforge/mysql/studio/

Price: free Express version, $49.95 (non-commercial standard version), $99.99 (non-commercial professional version).

License: commercial and non-commercial licenses. Provide subscription as an efficient and fast way to achieve product upgrade and technical support.

Supporting platform: Windows 2000, XP, Vista, 7

DbForge Studio for MySQL provides graphical MySQL development and management.

There are three versions: Express,Standard,Professional.

Express is a free application that provides basic functions for schema objects, user accounts, SQL scripts and queries.

Standard provides additional tools for database administrators and developers, such as debugger,Query Builder, code templates, object retrieval, various output and maintenance wizards.

Professional is a full-featured version and adds the following designs: database projects, accurate comparison and synchronization of database structures (schema comparisons) or database contents (data comparisons), debugging stored procedures and scripts, and creating complex queries.

Other tools for 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 version is free. The enterprise version of a single license is $69.90 USD. The Discounts version is applicable to the license.

License: the standard version is licensed under the standard free software conditions. The enterprise version is authorized by the sales unit.

Supporting platform: Windows 2000, XP, Vista, 7

Standard edition

Specially designed for personal use, it is equipped with minimum functions and is suitable for database novices to perform basic database management. You can use it free of charge on a non-commercial premise. If used for commercial use, you can purchase licenses and provide additional features.

Enterprise edition

Specially designed for enterprise use, it is more suitable for DBA and developers looking for integrated database management programs. You can try it before you buy it. The trial version of the enterprise version is full-featured, and you have 20 days to try it all and decide whether to buy it or not based on the full experience.

At the same time, it supports MySQL 3, 4 and 5.

10. MyDB Studio

Manufacturer: H2LSoft, Inc.

Website: http://www.mydb-studio.com/

Price: free of charge

Licensing: free software

Supporting 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, database synchronization, and data export / import. Database administrators can also use it to perform database transfers, as well as backups and restores. It supports the use of SSH tunnels to protect your links, even if your host does not allow remote access to links, user and rights management, and PHP script creation.

Thank you for reading this article carefully. I hope the article "what are the MySQL GUI tools" shared by the editor will be helpful to you. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.