Common MySQL graphical management tools

MySQL is a very popular small-scale relational database management system. 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 SQLyog (https://www.webyog.com/)

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. SQLyog compared to other similar MySQL database management tools have the following features: 1, based on C + + and MYSQLAPI programming, 2, convenient database synchronization and database structure synchronization tool; 3, easy to use database, data table backup and restore function; 4, support import and export XML, HTML, CSV and other formats of data; 5, run the bulk SQL script file directly, the speed is very fast, 6, the new version is added a powerful data migration application platform: Win2003/xp/2000/9x/linux/unix ref:http:// Www.lupaworld.com/article-206299-1.html

Common MySQL graphical management tools