One, phpMyAdmin

phpMyAdmin is the most commonly used MySQL maintenance tools, is a PHP development based on the Web way to structure in the web host MySQL management tools, support for Chinese, management database is very convenient. The downside is that it is not easy to backup and restore large databases.

Two, Navicat

Navicat is a desktop version of MySQL database management and development tools. And Microsoft SQLServer manager is very similar , easy to learn and easy to use.Navicat uses a graphical user interface that allows users to use and manage more easily. Support for Chinese, there is a free version available.

Three, MySQLDumper

MySQLDumper MySQL database backup and recovery program developed using PHP to solve the problem of using PHP for large database backup and recovery, hundreds of megabytes of databases can be easily backed up and restored without having to worry about slow Internet speeds leading to interruptions in the middle of the problem, very convenient and easy to use. This software is developed by Germans, there is no Chinese language package.

Four, MySQLODBCConnector

MySQL official ODBC interface program, the system installed this program, you can through the ODBC to access MySQL, so that you can realize the SQLServer, Aess and MySQL data conversion between, but also can support ASP access to the MySQL database.

V. MySQLGUITools

MySQLGUITools is the official graphical management tool provided by MySQL, which is very powerful and recommended, but unfortunately there is no Chinese interface.

Six: MySQLFront

A compact application for managing Mysql. The main features include a multi-document interface , syntax highlighting , drag-and-drop way of database and tables , editable/add/delete domains , editable/insert/delete records , members can be displayed , executable SQL scripts , provide interfaces with external programs , save data to a CSV file and so on. There is a Chinese interface.

In the development , testing process , some people like to use the command line operation , some like to use visualization tools to operate . They each have their own points

The following recommended a mysql visualization tool. workbench. this tool can be very good for mysql library operation

First go to download workbench: dev.mysql/downloads/workbench/

After the installation is completed, the Jump to the main interface, here, you can click on the main interface to connect to the database.

Connection interface, first write the name of the connection, then write the host ip, port. user name and password, and then test the connection. Then you can start the related operations