Free MYSQL client recommendation

 

According to a netizen, I got to know two very powerful but free models under windows.MySQLClient. A lightweight player, heidisql. Another important player is toad.
For MySQL, Which is http://www.toadsoft.com/tda/tdaindex.html, the series has severalDatabaseSystem support, such as Oracle, DB2, andSQLServer, the installation package is relatively large, but after installation, it is found that this tool is worth using in depth. It is highly customizable and supports skin replacement. His official introduction is home.
Of the world's #1 tool for database developers and DBAs! The tone is very big. It seems like it is not bad. Both of them are software under windows, and no versions under Linux are found at the moment. It is also a blessing for users under windows.

Navicat vs heidisql \

Comparison between two powerful MYSQL client software

First, navicat lite provides management of various database objects, including tables, stored procedures, views, triggers, and jobs; heidisql does not provide a user interface for creating triggers and jobs. However, heidisql provides some database statistical information Summary and database maintenance interface operations, which greatly facilitates the Administrator to monitor the database status. In this regard, navicat Lite is more suitable for database developers, heidisql is more suitable for database administrators, that is, DBAs.

From the user interface, heidisql is more concise. For example, when navicat lite wants to execute a query statement, it needs to click query on the left and then click Create query, heidisql can click query anywhere to directly enter the query editing interface. However, navicat lite provides a Chinese version, while heidisql does not. In addition, heidisql does not support simultaneous connection to multiple databases, while navicat lite does; in addition, navicat can save the executed SQL statements for the next execution, while heidisql maintains the executed SQL statements as logs, but the logs disappear at the next startup.

In terms of performance, there is no objective test method, and I personally feel that heidisql seems faster.

In the end, heidisql is a free and open-source software, while navicat Lite is only free.

In addition, heidisql is small, and the entire installation package only has 1.7 MB.