Install and Configure DBeaver on Fedora 35/34/33/32

Posted on 80 views

Welcome to our guide on how to install DBeaver CE Database Tool on Fedora 35/34/33/32. 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 35/34/33/32:

Step 1: Install Java (OpenJDK)

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.

sudo dnf install java-11-openjdk-devel

Confirm the installed Java version.

$ java -version
openjdk version "11.0.13" 2021-10-19
OpenJDK Runtime Environment 18.9 (build 11.0.13+8)
OpenJDK 64-Bit Server VM 18.9 (build 11.0.13+8, mixed mode, sharing)

Step 2: Download and Install DBeaver on Fedora

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:21.2.3-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 Fedora

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

launch-dbeaver-fedora

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

install-dbeaver-ubuntu-18.04-16.04-04

2. Provide database access details – Server, database user

install-dbeaver-ubuntu-18.04-16.04-05

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

install-dbeaver-ubuntu-18.04-16.04-06

Your connection test should then return a success.

dbeaver-mysql-connector

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

install-dbeaver-ubuntu-18.04-16.04-08

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

install-dbeaver-ubuntu-18.04-16.04-09-1024x468

You have learned to install DBeaver on Fedora 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.

 

coffee

Gravatar Image
A systems engineer with excellent skills in systems administration, cloud computing, systems deployment, virtualization, containers, and a certified ethical hacker.