Mysql-client tool Introduction

I just used my SQL and want to find a mysql client tool similar to the Enterprise Manager of ms SQL Server.

The following describes several common client tools:

 

1. EMS SQL manager for MySQL

Is a high-performance MySQL database server system management and development tool. It supports
Any version from 3.23 to 6.0, and supports the features of the latest MySQL version, including: viewing, storage procedures and functions, InnoDB external key words and other features. It provides a large number of tools to meet
All requirements of experienced users. A well-designed operating Wizard System and SQL manager
MySQL's artistic graphic user interface won't be bothered by the use of it even new users.

 

2. navicat

Navicat is a powerful MySQL database management and development tool. Navicat provides professional developers with a powerful enough cutting-edge tool, but it is still easy to learn for new users. Navicat uses an excellent graphical user interface (GUI) that allows you to quickly and easily create, organize, access, and share information in a secure and easier way.

 

3. phpMyAdmin

PhpMyAdmin is written in PHP and can be used to control and operate MySQL over the Internet. PhpMyAdmin can be used to operate databases, such as creating, copying, and deleting data.

 

4. mysql-front

A small MySQL management application. the main features include multi-Document Interface, highlighted syntax, databases and tables in the drag-and-drop mode, editable/addable/deleted domains, editable/insertable/deleteable records, and displayed members, executable SQL scripts provide interfaces with external programs to save data to CSV files.

 

5. sqlyog

Sqlyog is an easy-to-use, fast, and concise graphical tool for managing MySQL databases. It can effectively manage your databases anywhere, and it is completely free of charge! Functions:

Quick data backup and recovery;

Display Results in Grid/text format;

Supports selecting and filtering data from clients;

Execute large SQL script files in batches;

Fast execution of multiple queries and the ability to return more than 1000 records per page, which is directly generated in the memory;

The program itself is very short and concise! Only 348 KB after compression;

Fully use the MySQL C APIs program interface;

Create or edit a data table on the intuitive table interface;

Edit data on an intuitive table interface;

Manage indexes;

Create or delete a database;

Various permissions for manipulating databases: databases, tables, and fields;

Edit BLOB fields in bitmap/GIF/JPEG format;

The output data table structure/data is an SQL script;

Supports CSV files for input/output data;

The database list can be output as an HTML file;

Create logs for all operations;

Personal favorites management operation statement;

Supports highlighted syntax display;

Files in CSV, HTML, and XML format can be saved;

99% of the operations can be completed through the shortcut key;

Allows you to modify advanced attributes of a data table;

View various statuses and parameters of the data server;

You can change the data table types to isam, MyISAM, merge, heap, InnoDB, and bdb.

Refresh data servers, logs, permissions, tables, etc;

Diagnostic data tables: Check, compress, fix, and analyze data tables;

 

 

I am using EMS SQL manager for MySQL, and I feel very powerful and functional.