Shulou(Shulou.com)06/01 Report--

As a very popular and open source relational database, MySQL is widely used. Because of the open source of MySQL, there are many graphical management and maintenance workers. In addition to the command line management tools that come with the system, there are many other graphical management tools. Here, several frequently used MySQL graphical management tools are introduced for your reference. 0x01:Navicat

Navicat is a desktop version of MySQL database management and development tool. Much like Microsoft SQLServer Manager, it is simple, easy to learn and easy to use. Navicat uses a graphical user interface that makes it easier for users to use and manage, while supporting Chinese.

Official website

Https://www.navicat.com/

0x02:SQLyog

SQLyog Chinese version is a professional graphics management software, SQLyog operation is simple, powerful, can help users easily manage their own MYSQL database, SQLyog Chinese version supports a variety of data formats export, can quickly help users back up and restore data, but also quickly run SQL script files for users to provide convenience.

Official website

Https://www.webyog.com/

0x03:MySQL Workbench

MySQL Workbench is an ER/ database modeling tool designed specifically for MySQL. It is the successor to the famous database design tool DBDesigner4. You can use MySQL Workbench to design and create new database diagrams, create database documents, and perform complex MySQL migrations. MySQL Workbench is the next generation of visual database design and management tools, it has both open source and commercial versions. Both Windows and Linux systems are supported.

Official website

Https://www.mysql.com/products/workbench/

0x04: MySQL GUI Tools

MySQL GUI Tools is a MySQL database management console with a visual interface, providing four very easy-to-use graphical applications to facilitate database management and data query. MySQL GUI Tools can greatly improve the efficiency of database management, backup, migration and query, even if users do not have a rich foundation of the SQL language. This graphical management tool is the oldest management tool.

Official website

Https://downloads.mysql.com/archives/gui/

0x05:MySQL Connector/ODBC

MySQL Connector/ODBC can sometimes be called MyODBC, and users can connect to Mysql's server through ODBC (Open Database Connectivity) database. For example, you can use applications from Windows or Unix platforms, such as Microsoft's Access, Excel, and Borland's Delphi, to connect to the database server. MySQL Connector/ODBC is officially provided by MySQL. After installing this program, the system can access MySQL through ODBC, so that you can achieve data conversion between SQLServer, Access and MySQL, and also support ASP to access MySQL databases.

Official website

Https://dev.mysql.com/downloads/connector/odbc/

0x06:phpMyAdmin

PhpMyAdmin is the most commonly used MySQL maintenance tool. It is a Web-based MySQL management tool developed by PHP on the host of the website. It supports Chinese, and it is very convenient to manage the database. It is the standard configuration of PHP development software in windows. The deficiency is that it is not convenient for the backup and recovery of large databases.

Official website

Https://www.phpmyadmin.net/

0x07:MySQLDumper

MySQLDumper uses the MySQL database backup and recovery program developed by PHP to solve the problem of using PHP to backup and restore large databases. Hundreds of megabytes of databases can be easily backed up and restored, and there is no need to worry about the interruption caused by slow network speed. This software was developed by Germans and there is no Chinese language pack yet.

Official website

Http://www.mysqldumper.de

Original address: https://www.linuxprobe.com/common-graphical-tools.html

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.