(Last Updated On: June 25, 2019)

Welcome to our guide on how to install DBeaver CE Database Tool on Fedora 30/29 & CentOS 7/8. DBeaver CE is a free and open source multi-platform database management tool/SQL client based on Eclipse platform and designed for SQL programmers, Developers, Analysts, and Database administrators.

DBeaver has support for any database system which uses JDBC driver – MySQL/MariaDB, Oracle, PostgreSQL, Google BigQuery, DB2 LUW, Exasol, SQL Server, SQLite, Sybase/SAP ASE, Firebird, H2, HSQLDB, Derby, Teradata, Vertica, Netezza, Informix, etc.

For use with non-JDBC data sources such as MongoDB, WMI, Redis, Cassandra, you’ll need an upgrade to DBeaver Enterprise Edition. DBeaver is a good workbench tool for building SQL queries, editing, and transferring data, viewing trees of objects, completing database administration tasks, monitoring database connection sessions, and a lot more.


Follow a few steps outlined below to install and Configure DBeaver on Fedora 30/29 & CentOS 7/8.

Step 1: Install Java

The main requirement for running DBeaver is Java. Ensure you have Java installed on your CentOS 7/8 & Fedora 30/29 system. The latest release of DBeaver supports Java 11 LTS.

---- RHEL 8 / CentOS 8 / Fedora 30+ --------
$ sudo dnf install java-11-openjdk-devel

---------- Java 8 ------------------
$ sudo yum install java-1.8.0-openjdk  java-1.8.0-openjdk-devel

For Java 11 on CentOS 7 / Fedora 29: Install Java 11 on CentOS 7 / Fedora

Confirm the installed Java version.

$ java -version
openjdk version "11.0.3" 2019-04-16
OpenJDK Runtime Environment (build 11.0.3+4)
OpenJDK 64-Bit Server VM (build 11.0.3+4, mixed mode)

$ java -version
openjdk version "1.8.0_212"
OpenJDK Runtime Environment (build 1.8.0_212-b04)
OpenJDK 64-Bit Server VM (build 25.212-b04, mixed mode)

Step 2: Download and Install DBeaver

After installation of Java, download the latest DBeaver RPM package.

sudo yum -y install wget
wget https://dbeaver.io/files/dbeaver-ce-latest-stable.x86_64.rpm

Install the package with rpm/dnf or yum package manager.

$ sudo rpm -Uvh ./dbeaver-ce-latest-stable.x86_64.rpm
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...
   1:dbeaver-ce-0:6.1.1-stable        ################################# [100%]

Step 3: Prepare Database Server

Before launching and configuring DBeaver service, you may first need to create a database and database user to connect to. For this demonstration, I’ll use the MariaDB database server.

Install MariaDB on CentOS 7

Install MariaDB on Fedora

Install MariaDB Database on CentOS / RHEL 8

Once you have a database server, log in to MySQL shell as root user and create a test database to connect from DBeaver Database tool.

$ mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 48
Server version: 10.3.11-MariaDB-1:10.3.11+maria~bionic-log mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> CREATE DATABASE test_db;
MariaDB [(none)]> CREATE USER 'test_user'@'localhost' IDENTIFIED BY 'StrongPassword';
MariaDB [(none)]> GRANT ALL PRIVILEGES ON test_db.* TO 'test_user'@'localhost';
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> QUIT;

Step 4: Launching DBeaver

You can either launch DBeaver from your terminal or Applications Launcher for your Desktop Environment.

$ dbeaver

Or

1. Create a new database connection – Specify database type.

2. Provide database access details – Server, database user

3. Click “Test Connection” to verify the connection. When asked to download mariadb connection driver, please agree by clicking Download button.

Your connection test should then return a success.

You should now see database created earlier under MariaDB connection profile.

You can now manage your database, tables, triggers, Procedures, Views, Events e.t.c using DBeaver.

You have learned to install DBeaver on Fedora & CentOS workstation. Enjoy using SQL editor provided by DBeaver to generate and test SQL queries on a GUI as opposed to CLI.

For Ubuntu check: Install and Configure DBeaver on Ubuntu / Debian.

Related:

Install Dgraph on CentOS 7 / Ubuntu 18.04

How to Install PostGIS on CentOS 7