How to use MySQL client DBeaver in Linux Desktop Application

This article is about how to use MySQL client DBeaver in Linux desktop applications. I think it is very practical, so I share it with you. I hope you can get something after reading this article. Let's take a look at it.

Brief introduction

There are many MySQL clients on Windows, but not many of them are easy to use and compatible on Linux. The official mysql-bench is a good choice, but it depends too much. I use Manjaro because of its introduction, and I don't like to install too many things.

Later found DBeaver, a very powerful and easy-to-use database management and development tool. It's been used for several years, but it hasn't been changed.

Databases that support connections: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, Db2, SQL Server, Sybase, MSAccess, Teradata, Firebird, Derby, and so on. The commercial version can support a variety of NoSQL and big data platforms: MongoDB, InfluxDB, Apache Cassandra, Redis, Apache Hive and so on.

Installation

Install directly using the pacman command.

Sudo pacman-S dbeaver

After installation, open it directly and you can use it directly.

Use

Dbeaver supports a variety of database connections, but I usually use mysql, sqlite, and so on, which is enough for me.

Dbeaver

When connecting, you need to install the driver package. The drivers of mysql5.7 and mysql8 are different, but they can be used together and choose different versions to connect.

Driver download

By default, download the corresponding jar package to the official. The speed is a bit slow. We can use domestic mirror sources to speed up the download.

Window-preferences-Connect-driver-Maven interface, click add next to the warehouse.

Using dbeaver, you can directly copy table data into SQL, which is very convenient.

There is also imported data, which can be imported directly from one connected table to another, which enables rapid data migration, which is very suitable for small data migration.

There are many features that can be used to try.

The above is how to use the MySQL client DBeaver in Linux desktop applications. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.