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-develConfirm 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.rpmInstall 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.
$ dbeaverOr
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 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.
