Common MySQL graphical management tools

MySQL has a lot of management and maintenance tools, in addition to the system comes with the command-line management tools, there are many other graphical management tools, here I introduce several frequently used MySQL graphical management tools for your reference.

MySQL is a very popular small relational database management system, was acquired by Sun Company on January 16, 2008. MySQL is now widely used in small and medium-sized websites on the internet. Because of its small size, fast speed, low total cost of ownership, especially the open source, many small and medium-sized web sites in order to reduce the total cost of ownership of the site chose MySQL as the site database.

1, PhpMyAdmin(http://www.phpmyadmin.net/)

phpMyAdmin is the most commonly used MySQL maintenance tool, is a PHP development Web-based architecture on the site host MySQL management tools, support Chinese, management database is very convenient. The disadvantage is that it is inconvenient to backup and restore the large database.

2, Mysqldumper(http://www.mysqldumper.de/en/)

Mysqldumper use PHP developed MySQL database backup recovery program, solve the use of PHP for large database backup and recovery problems, the hundreds of trillion database can be easily backup recovery, do not worry about the slow speed caused by the middle of the problem, very easy to use. The software was developed by the Germans and there is no Chinese language pack.

3, Navicat(http://www.navicat.com/)

Navicat is a desktop version of MySQL database management and development tools. Like Microsoft SQL Server Manager, it's easy to learn and use. Navicat uses a graphical user interface that makes it easier for users to use and manage. Support in Chinese, free version available.

4. MySQL GUI Tools(http://dev.mysql.com/downloads/gui-tools/)

MySQL GUI Tools is the official MySQL provided by the graphical management tools, the function is very powerful, it is worth recommending, unfortunately there is no Chinese interface.

5. MySQL ODBC Connector(http://dev.mysql.com/downloads/connector/odbc/)

MySQL is the official ODBC interface program, after the system installed this program, you can access MySQL through ODBC, so that you can achieve data conversion between SQL Server, Access and MySQL, but also support the ASP to access the MySQL database.

6. MySQL Workbench(http://dev.mysql.com/downloads/workbench/)

MySQL Workbench is a unified visual development and management platform that provides a number of advanced tools to support database modeling and design, query development and testing, server configuration and monitoring, user and security management, backup and recovery automation, audit data inspection, and wizard-driven database migrations. MySQL Workbench is a Visual Database design software released by MySQL AB, formerly known as the Fabforce Company's Ddesigner 4. MySQL Workbench provides database administrators, program developers, and system planners with visual design, model creation, and database management capabilities. It contains the ER model for creating complex data modeling, forward and reverse database engineering, and can also be used to perform difficult-to-change and manageable document tasks that typically take a lot of time and need. The MySQL workbench can be used on Windows,linux and Macs.

7, SQLyog (http://sqlyog.en.softonic.com/or Https://www.webyog.com/product/sqlyog)

SQLyog is an easy-to-use, fast and concise tool for graphically managing MySQL databases, and it is able to effectively manage your database from any location.

SQLyog is a simple, efficient and powerful graphical MySQL database management tool produced by the industry-renowned Webyog company. With SQLyog, you can quickly and intuitively maintain a remote MySQL database from anywhere in the world through the network.

Common MySQL graphical management tools