How To Install DBeaver on Ubuntu 20.04 LTS

In this tutorial, we will show you how to install DBeaver on Ubuntu 20.04 LTS. For those of you who didn’t know, DBeaver is a client for database managers, which allows managing in a comfortable way the data and options of the database instance. DBeaver supports any database which has JDBC driver – MySQL/MariaDB, PostgreSQL, Oracle, DB2 LUW, Google BigQuery, Exasol, SQL Server, Sybase/SAP ASE, SQLite, Firebird, H2, HSQLDB, Derby, Teradata, Vertica, Netezza, Informix, etc. If you need support for non-JDBC data sources such as WMI, MongoDB, Cassandra, Redis, then consider using DBeaver Enterprise Edition.

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo‘ to the commands to get root privileges. I will show you the step-by-step installation of the DBeaver on Ubuntu 20.04 (Focal Fossa). You can follow the same instructions for Ubuntu 18.04, 16.04, and any other Debian-based distribution like Linux Mint.

Prerequisites

• A server running one of the following operating systems: Ubuntu 20.04, 18.04, and any other Debian-based distribution like Linux Mint or elementary OS.
• It’s recommended that you use a fresh OS install to prevent any potential issues
• A non-root sudo user or access to the root user. We recommend acting as a non-root sudo user, however, as you can harm your system if you’re not careful when acting as the root.

Install DBeaver on Ubuntu 20.04 LTS Focal Fossa

Step 1. First, make sure that all your system packages are up-to-date by running the following apt commands in the terminal.

sudo apt update
sudo apt upgrade

Step 2. Installing Java.

Now install Java and set it as default Java on your Ubuntu using the following command below:

sudo apt install openjdk-11-jdk openjdk-11-jre

Step 3. Installing DBeaver on Ubuntu 20.04.

• Install DBeaver from the official repository.

Run the below commands to add the DBeaver repository:

wget -O - https://dbeaver.io/debs/dbeaver.gpg.key | sudo apt-key add -
echo "deb https://dbeaver.io/debs/dbeaver-ce /" | sudo tee /etc/apt/sources.list.d/dbeaver.list

Then, install DBeaver using the following command:

sudo apt update
sudo apt install dbeaver-ce

• Install DBeaver from the official website:

We will manually download the Debian package of Dbeaver to install it on the Ubuntu system:

wget https://dbeaver.io/files/dbeaver-ce_latest_amd64.deb

Next, run the installer:

sudo dpkg -i dbeaver-ce_latest_amd64.deb

• Install DBeaver via Snap.

Run the following command to install Snap packages to your system:

sudo apt install snapd

sudo snap install dbeaver-ce

• Install DBeaver using the Ubuntu PPA repository.

Run the following command to install it:

sudo add-apt-repository ppa:serge-rider/dbeaver-ce
sudo apt update
sudo apt install dbeaver-ce

Step 4. Accessing DBeaver on Ubuntu.

Once successfully installed, you can either Launch DBeaver from your terminal or Applications Launcher for your Desktop Environment.

Congratulations! You have successfully installed DBeaver. Thanks for using this tutorial for installing the DBeaver on Ubuntu 20.04 LTS Focal Fossa system. For additional help or useful information, we recommend you check the official DBeaver website.