Recommend several easy-to-use MySQL open source clients, it is recommended to collect

说实话,These clients are very easy to use,尤其是 Navicat,功能强大、操作流程、简单易用,And there are many types of databases that can be connected,It is also my favorite database client.

但是,天下没有免费的午餐,These clients are fee-based,以 Navicat 为例,If it is a personal version,The one-year usage fee is 2899 元,You can enjoy the upgrade service for free,Of course you can also buy it once,费用为 5699元,However, service upgrades are not available for free,The enterprise version is more expensive.

因此,If the individual or company decides to use it Navicat,It is recommended to buy the genuine one,If using the cracked version,会存在法律风险,一经发现,They will sue you for infringement,At the same time will be based on your commercial use,要求赔偿.It's easy to crack,But I really don't recommend it to everyone,You can learn by yourself,But try not to take it out and use it directly.

当然说这么多,I'm not here to advertise it,Navicat 虽然好用,But there are also many tools on the market that can manage databases,If you don't want to spend money to buy services,Want to use free and easy-to-use client tools,I want the content of this article,It will be worthy of your possession and collection！

接下来, Let's take a look at what free and easy-to-use clients are currently on the market.

一、Free client

1.MySQL Workbench

MySQL Workbench MySQL 是官方提供的图形化管理工具,支持数据库的创建、设计、迁移、备份、导出和导入等功能,分为社区版和商业版,社区版完全免费,而商业版则是按年收费,compared to the free version,Expanded with many new features,并且支持 Windows、Linux 和 mac 等主流操作系统.

特点如下：

• 由 oracle 开发,性能稳定、功能强大
• Windows、macOS、Linux 等主流操作系统上,都能安装
• Allows viewing server status、运行状况, and server logs

The download address of the community edition is as follows：MySQL Workbench

2.phpMyAdmin

phpMyAdmin 是一个以 PHP 为基础,以 Web-Base 方式架构在网站主机上的 MySQL 的数据库管理工具,Allows users to manage through the web interface MySQL 数据库,Also one of the most popular tools of its kind,Mainly because it's so easy to use,并且完全免费.

特点如下：

• Based on web design,完全跨平台,Most computers have easy access
• 提供80种语言选项,Contains both left-to-right and right-to-left languages
• 易于安装和使用

软件的下载地址如下：phpmyadmin.net

3.HeidiSQL

HeidiSQL Is a lightweight free MySQL 客户端工具,可用于处理 MySQL 数据库,其中包括浏览/编辑数据、创建/修改表、Manage user permissions and other tasks,功能比较齐全.

特点如下：

• 安装包非常小,界面操作简单,很容易上手
• Provides installation-free operation,It does not have to be installed on the hard disk,Open the program can be used directly
• 目前只支持 windows 平台

If your current operating platform is windows,选择 HeidiSQL 作为 Mysql The client would be a very good choice.

软件的下载地址如下：heidisql.com

4.Sequel Pro

Sequel Pro 是一款高颜值的 MySQL 数据库管理工具,界面简洁易用,All basic tasks can be performed,例如添加、修改、删除、浏览、过滤数据库、表、记录,and functions such as executing queries,It's also completely free,不过目前仅支持 macos 平台.

特点如下：

• 支持所有版本的 MySQL 服务器
• 界面非常的简洁,很容易上手
• 目前只支持 macos 平台

Sequel Pro It is also a client tool I am using,老实说,界面非常简洁,操作非常容易,查询速度超快,如果你目前使用的是 macos 系统,Then I recommend you to use it as the first choice mysql 客户端工具.

软件的下载地址如下：sequelpro.com

5.DBeaver

DBeaver It is a very famous general database management software,基于 Java 开发,Support almost all mainstream databases,包括 MySQL、PostgreSQL、Oracle、DB2等(只要具有JDBC驱动即可),The database directory structure can be easily viewed、Import and export databases and execute related script operations,对于管理 MySQL 数据库来说,也是一个非常不错的选择,

DBeaver There are also community editions and professional editions,社区版免费,支持主流的关系型数据库,连 Hive 都支持.专业版除了支持关系型数据库外,还支持非关系型数据库,比如 MongoDB、redis等等.

特点如下：

• 功能强大,性能稳定
• Windows、macOS、Linux 等主流操作系统上,都能安装
• The variety of supported databases is very wide,oracle、sql server、mysql、postgresql、db2等等,都能连接

DBeaver It is also a client tool that I often use,compared to the above tools,DBeaver One good thing is that it's very generic,Basically all relational databases can be connected,Basic addition, deletion, modification, and query operations for the database,DBeaver 完全能胜任.But in terms of experience,such as functional operations,DBeaver A little more complicated than other clients,It takes learning to get started.

软件的下载地址如下：dbeaver.io

6.命令行工具

Of course there are also gods,比如很多 dba,Look down on these people who use visual client tools,They chose to strike back at us nerds by knocking orders,Of course, it is expected that netizens also have this unique ability.

mysql 服务器在安装的时候,In fact, it already comes with a client command tool,如果你懂一些 mysql 命令,The database can be managed directly from the command line,And the operation is smooth！

二、小结

These client tools are introduced to you today,都有一个共同点,That is easy to use and free,期望能帮助到大家！