No harm, today is just to recommend you some MySQL clients, these clients have one thing in common, that is, easy to use and free.

“Harm, I think is also plain!” Then, turn around and download it.

Which do the development around the database, in terms of relational data, use the most is MySQL, Oracle, Microsoft SQL Server, Oracle is good to use but pay, Microsoft SQL Server pay and somebody else’s own client is very good to use, The rest of MySQL is free to use, but the client side is pretty boring.

Navicat is the most useful client for MySQL, but Navicat is not free. It is quite expensive and unnecessary for individual developers.

Of course, there are free versions of everything on the Internet, and you may not believe yourself if you say you’ve never used version XX. In private use it is nothing, but which day meet with the legitimate player, also really a little embarrassed to take.

Don’t panic, here are a few legitimate and free MySQL clients to make sure you get your hands on them.

MySQL WorkBench

MySQL WorkBench is an official client that supports Mac, Windows and Linux. Because it is the official product, so the function is more complete. I used to work in.NET development. At that time, I worked with Microsoft SQL Server every day, so I am very familiar with the interface style of MySQL WorkBench, which is very similar to Microsoft SQL Server. Even the style of Visual Studio is similar to that of the first IDE in the universe. So, I suspect it borrows from Microsoft’s style.

image-20200707100643416

Style does not matter, it is important to use.

Let’s just say you’ve used Navicat, right? Navicat has all the features.

  • Support database structure management, including database, table structure, data management;
  • Support ER model management, including forward and reverse engineering;
  • Support visual effects dashboard; image-20200707101718124
  • Support data migration, such as migrating from Microsoft SQL Server to MySQL;

Website address: www.mysql.com/products/wo…

Sequel Pro

Mac only, but the function is relatively complete.

Supports database management. You can add and modify the database. Table structure, content, and association can be managed on the GUI.

There are two more handy operations that list all the Server Variables.

Server Processes can be listed

Sequelpro.com/

Beekeeper Studio

Mac, Windows, Linux, but the function is relatively simple. Support not only MySQL, but also other databases.

Dark style, very high.

However, it only supports SQL statements and does not support complex management.

Queries can be saved and history records can be automatically recorded.

Official website: www.beekeeperstudio.io/

HeidiSQL

Only Windows is supported. The function is quite complete. Support structure management and data content management.

img

Official website: www.heidisql.com/

DBeaver

The community edition is free, but supports mainstream relational databases, including Hive. The Professional edition supports non-relational databases as well as relational databases. Mac, Windows, Linux, and Eclipse plug-ins are also available.

img

Dbeaver.io /

The last

In the end, the big guy chose the command line.