1. EMS SQL Manager for MySQL
is a high-performance MySQL database server System management and development tools. It supports any version from MySQL 3.23 to 6.0 and supports the latest version of MySQL features, including: viewing, storing procedures and functions, innodb external keys, and other features. It provides a number of tools to meet all the requirements of experienced users. Added a well-designed Operation Wizard system, as well as the artistic graphical user interface of SQL Manager for MySQL, even novice users will not be bothered by how to use it.
2. NaviCat
Navicat is a powerful MySQL database management and development tool. NAVICAT provides professional developers with a powerful and sophisticated set of tools, but it is still easy to learn for new users. Navicat, using an excellent graphical user interface (GUI), allows you to quickly and easily create, organize, access, and share information in a safe and easy way.
3. PhpMyAdmin
phpMyAdmin is a PHP-based program that can control and manipulate MySQL over the internet. With phpMyAdmin, you can fully manipulate the database, such as setting up, copying/deleting data, and so on.
4. Mysql-front
A small app for managing MySQL. Main features include multi-document interface, syntax highlighting, drag-and-drop database and table, editable/Add/remove fields, editable/pluggable/deleted records, can display members, executable SQL scripts, provide interface with external programs, save data to CSV file, etc.
5. SQLyog
SQLyog is an easy-to-use, fast and concise tool for graphically managing MySQL databases, which manages your database in any location, and is completely free of charge! The functions are as follows:
Fast backup and recovery of data;
Display results in grid/text format;
Support clients to select and filter data;
Bulk execution of large SQL script files;
Fast execution of multiple queries and the ability to return a recordset of more than 1000 records per page, which is generated directly in memory;
The program itself is very short and concise! Only 348 KB after compression;
Full use of the MySQL C APIs program interface;
Create or edit data tables with an intuitive tabular interface;
Edit data in an intuitive tabular interface;
Perform index management;
Create or delete a database;
Manipulate the various permissions of the database: library, table, field;
Edit field of BLOB type, support bitmap/gif/jpeg format;
Output data table structure/data is SQL script;
Support input/output data for CSV file;
You can export the database manifest as an HTML file;
Establish logs for all operations;
Personal collection management operation statement;
supports syntax highlighting;
Can save the recordset as CSV, HTML, XML format files;
99% of the operation can be done by shortcut keys;
Support for various advanced property modification of the data table;
View the various status, parameters, etc. of the data server;
Support for changing data table types for ISAM, MYISAM, MERGE, HEAP, InnoDB, BDB
Refresh data servers, logs, permissions, tables, etc.;
Diagnostic Data Sheet: Inspection, compression, repair, analysis;
5 useful MySQL Clients
