In this tutorial, we will show you how to install DBeaver on AlmaLinux 8. For those of you who didn’t know, DBeaver is a free and open-source universal database tool for developers and database administrators. DBeaver supports any database that uses JDBC driver for relational databases i.e PostgreSQL, MySQL/MariaDB, Oracle, BigQuery, Google, Exasol, SQLite, DB2, Teradata, LUW, Firebird, Vertica, Informix, Netezza, H2, and many more.
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 free universal database tool on an AlmaLinux 8. You can follow the same instructions for CentOS and Rocky Linux.
Prerequisites
- A server running one of the following operating systems: AlmaLinux 8, CentOS or Rocky Linux 8.
- It’s recommended that you use a fresh OS install to prevent any potential issues
- A
non-root sudo useror access to theroot user. We recommend acting as anon-root sudo user, however, as you can harm your system if you’re not careful when acting as the root.
Install DBeaver on AlmaLinux 8
Step 1. First, let’s start by ensuring your system is up-to-date.
sudo dnf update sudo dnf install epel-release
Step 2. Installing Java.
The requirement for running DBeaver is Java. Run the following command to install Java to your system:
sudo dnf install java-11-openjdk-devel
Verify your installed Java version:
java -version
Step 3. Installing DBeaver on AlmaLinux 8.
By default, DBeaver is not available on the AlmaLinux 8 base repository. Now we run the following command to download the latest DBeaver RPM file from the official page:
wget https://dbeaver.io/files/dbeaver-ce-latest-stable.x86_64.rpm
Then, install the DBeaver Community Edition package using the following command below:
sudo rpm -Uvh ./dbeaver-ce-latest-stable.x86_64.rpm
Step 4. Configure Database Server.
Before launching the DBeaver service, you may first need to create a database and database user to connect to. For this example, I’ll use the MariaDB database server.
Log in to the MariaDB shell as a root user and create a test database to connect from the 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.4.12-MariaDB-1:11.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 idroot_db;
MariaDB [(none)]> CREATE USER 'idroot_user'@'localhost' IDENTIFIED BY 'Your-Strong-Password';
MariaDB [(none)]> GRANT ALL PRIVILEGES ON idroot_db.* TO 'idroot_user'@'localhost';
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> QUIT;
Step 5. Accessing DBeaver on AlmaLinux.
Once successfully installed, now launch the activities search bar and type “DBeaver”. Click on the DBeaver icon and launch it.
Congratulations! You have successfully installed DBeaver. Thanks for using this tutorial for installing the DBeaver free universal database tool on your AlmaLinux 8 system. For additional help or useful information, we recommend you check the official DBeaver website.
