MySQL is a very popular small relational database management system, January 16, 2008 by Sun Company acquired. Currently, MySQL is widely used in small and medium Web sites on the Internet. Because of its small size, speed, the total cost of ownership is low, especially the characteristics of open source, many small and medium-sized Web sites in order to reduce the total cost of ownership of the site to choose MySQL as a Web site database.
1, phpMyAdmin (http://www.phpmyadmin.net/)
phpMyAdmin is the most common MySQL maintenance tool, is a PHP development based on the web-style architecture on the Web site MySQL management tools, support Chinese, management database is very convenient. The disadvantage is that it is inconvenient to backup and restore large databases.
2, Mysqldumper (http://www.mysqldumper.de/en/)
Mysqldumper use PHP to develop the MySQL database backup recovery program, to solve the use of PHP for large database backup and recovery problem, hundreds of trillion database can be convenient backup recovery, do not worry about slow speed caused intermediate interruption of the problem, very user-friendly. The software is developed by the Germans and has no Chinese language packs.
3, Navicat (http://www.navicat.com/)
Navicat is a desktop version of MySQL database management and development tools. Similar to Microsoft SQL Server's manager, easy to learn and easy to use. Navicat uses a graphical user interface to make it easier for users to use and manage. Support Chinese, free version available.
4. MySQL GUI Tools (http://dev.mysql.com/downloads/gui-tools/)
MySQL GUI Tools is a MySQL official 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 officially provided by the ODBC interface program, the system installed this program, you can access MySQL through ODBC, so that you can implement SQL Server, access and MySQL data conversion, but also support ASP access to the MySQL database.
The above is the five common MySQL maintenance management tools I introduced, if you know better MySQL tools, please leave a message and share with us.
(Author blog: www.williamlong.info)