14 Classic MySQL Client software

1. EMS MySQL Manager

A powerful MySQL management tool that allows users to create or edit database objects through a graphical interface, provide the ability to manage users and permissions through SQL statements, create SQL statements from a graphical interface, automatically generate HTML-formatted database documents, import/export data, view/Edit BLOB fields, and more.

Official website: Http://sqlmanager.net/products/mysql/manager

English: http://download.pchome.net/development/database/download-10462.html

This software gives me the feeling is concise, practical, professional, I have been using this, it is highly recommended you use.

2. Mysql-front

MySQL database graphics tools, main features include multi-document interface, syntax highlighting, drag-and-drop database and table, editable/can add/remove fields, editable/pluggable/deleted records, can display members, executable SQL scripts, provide interface with external programs, save data to CSV file etc.

English: http://down.chinaz.com/soft/21500.htm

3. Navicat for MySQL

A set of tools for database management, reporting, and monitoring of MySQL database systems in graphical format. The new version features high performance, business intelligence, and powerful backup capabilities, plus a number of improvements. Contains Simplified Chinese files.

Official website: www.navicat.com

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

English: http://down.chinaz.com/soft/22655.htm

4. Mysqlyog

Mysqlyog software is written in pure Java software, can run in the Windows,linux,unix system, the basic version can achieve basic management of the database, visual creation of tables, views, triggers, database hot backup, recovery, remote management system and other functions.

Official website: http://www.webyog.com

Official: http://www.webyog.com/en/downloads.php

5. MySQL Browser

MySQL browser advantage is simple, extremely simple, after installation can immediately get started, immediately can use the kind, layout is very humble, the function is very humble, simple to use no problem, especially just start learning MySQL children's shoes, you can try.

Official: http://dev.mysql.com/downloads/gui-tools/5.0.html

6. Workbench

MySQL Workbench is a Visual Database design tool that blends SQL development, management, and database design, creation, and maintenance into a simple development environment, originating from Fabforce.net, a successor to Dbdesigner 4, and replacing MySQL GUI tool bindings. The current version is 5.2, and the first version is 5.0, and it needs to be emphasized that MySQL Workbench was developed as a successor to Dbdesinger 4.

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

7. Sequel Pro

Sequel Pro is a free open source project, it is the successor of CocoaMySQL database management system, COCOAMYSQL is the product of Lorenz Textor mental work, and Lorenz Textor is from 2003 onwards, CocoaMySQL is the main developer.

Sequel Pro is used to manage the MySQL database (local or Internet), which allows you to add, delete databases and tables, change fields, indexes, and views, filter table content, add, edit, and delete columns, execute custom queries and dump table and entire database

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

Official website: http://www.sequelpro.com/

　　8. Heidisql

Heidisql, formerly known as Mysql-front, is a free open source client developed by German programmers Ansgar Becker and some of those who have made outstanding contributions in the field of Delhi. With the Heidisql management database, the user must authenticate to a local or remote MySQL server to create a session. In this session, the user can manage the MySQL database by connecting to the MySQL server, and the session end will disconnect from the server. Its feature set is sufficient for most ordinary and advanced database, table, and data operations, but it remains actively developed in order to make it perfect.

A version written by Java, Jheidi, was designed to work on Mac and Linux computers, and unfortunately this project was halted in March 2010.

Official website: http://www.heidisql.com/

9.phpMyAdmin

phpMyAdmin is written by PHP to manage MySQL over the internet, phpMyAdmin supports a wide range of operations for MySQL, and the most frequent uses are database management, tables, fields, relationships, indexes, users, and permissions. You can also execute SQL statements directly.

Official website: http://www.phpmyadmin.net/home_page/

SQL Maestro MySQL Tools Family

SQL Maestro Group provides complete database management, development and management tools for most popular database management systems, through which you can execute queries and SQL scripts, manage users and their authorizations, import, export, and back up data. In addition, you can generate PHP scripts for the tables and queries you choose, and you can convert any ADO-compatible database into a MySQL database.

This binding contains the following components:

SQL Maestro for MySQL

A professional MySQL GUI management tool that supports all the latest MySQL 5.0 and 5.1 features, such as: views, stored procedures, triggers, and table partitioning.

Data Wizard for MySQL

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

Code Factory for MySQL

A set of tools for editing SQL scripts and visualizing the creation of SQL statements.

Service Center for MySQL

Easy MySQL Database maintenance

PHP Generator for MySQL

Produce high-quality MySQL PHP scripts that are available in a free version.

Official website: http://www.sqlmaestro.com/products/mysql/

Sqlwave.

Nerocode Sqlwave is a MySQL GUI client tool designed to automate and streamline the database development process. It also provides an easy way to browse and maintain existing databases, design complex SQL statements in different ways, and query and manipulate data. Compatible with MySQL 4.x–6.x.

The 30-day trial version is available.

Official website: http://www.nerocode.com/

Dbforge Studio

Dbforge Studio for MySQL provides visual MySQL development and management,

Available in three versions: Express (Express), Standard and Pro (Professional).

Express Line is a free app that provides basic functions such as working with schema objects, user accounts, SQL scripts, and query statements.

The Standard Edition prepares additional tools for database administrators and program developers. For example, the debugger (debugger), query Builder, code template (templates), object search, variable Export and Maintenance Wizard.

The Professional edition is the most functional version and adds the following features: Database engineering, exact comparison, database structure synchronization or database content synchronization, debugging stored procedures and scripts, and building complex queries.

Other tools for Dbforge include:

? Schema Compare for MySQL

? Data Compare for MySQL

? Query Builder for MySQL

? Fusion for MySQL

Official website: http://www.devart.com/dbforge/mysql/studio/

DBTools Manager

Standard Edition

Designed specifically for the individual, it has the smallest feature set, which makes it the ideal tool for new database users to perform basic data management, you can use this version for free, for commercial applications, you can purchase a license, it will provide you with additional features.

Enterprise Edition

Designed for enterprise use, this is ideal for DBAs and program developers who want to find an integrated database management system. You can try it before you buy, the Enterprise Trial version will open all the features and you have 20 days to decide whether to buy it.

Two versions are supported for MySQL 3, 4 and 5.

Official website: http://www.dbtools.com.br/EN/dbmanagerpro/

MyDB Studio

MyDB Studio includes a complete toolset for MySQL server management, and developers will appreciate the ability to create, edit, remove database objects, database synchronization, data import and export, and DBAs to perform database porting with MyDB Studio, as well as data backup and re-storage. It supports SSH tunneling technology to make your connection more secure.

Official website: http://www.mydb-studio.com

Source: http://www.admin10000.com/document/132.html

From for notes (Wiz)

14 Classic MySQL client software