Bobcares

Install and Configure DBeaver on Ubuntu 20.04/18.04/16.04 & Debian 10/9

by | Oct 12, 2020

Are you looking for steps to install DBeaver on Ubuntu? Here’s how we do it.

Here at Bobcares, we have seen several such Ubuntu related installations as part of our Server Management Services for web hosts and online service providers.

Today we’ll see how to install DBeaver on Ubuntu.

 

A few facts about DBeaver

DBeaver CE is a free and open-source SQL client that is mainly designed for Developers, SQL programmers, Analysts, and Database administrators.

Moreover, it supports any database which has a JDBC driver. However, if you need support for non-JDBC data sources then you can consider using DBeaver Enterprise Edition.

DBeaver is based on the Eclipse platform and is a good workbench tool for building SQL queries, editing, and transferring data, viewing trees of objects, and a lot more.

 

Install DBeaver on Ubuntu 20.04/18.04/16.04 and Debian 10/9

Now let’s see how our Support Engineers DBeaver on Ubuntu.

 

1. Install Java on Ubuntu / Debian

To install java and set as default Java on your Ubuntu 20.04/18.04/16.04, run the below command.

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

Make sure to confirm the version.

$ java -version
openjdk version "11.0.5" 2019-10-15
OpenJDK Runtime Environment (build 11.0.5+10-post-Ubuntu-0ubuntu1.118.04)
OpenJDK 64-Bit Server VM (build 11.0.5+10-post-Ubuntu-0ubuntu1.118.04, mixed mode, sharing)

 

Install OpenJDK on Debian 10/9

The default Java development and runtime available on Debian 10/9 repository is OpenJDK. So install it by running the below command.

sudo apt -y install default-jdk

Make sure to check the Java version.

$ java -version
openjdk version "1.8.0_181"
OpenJDK Runtime Environment (build 1.8.0_181-8u181-b13-2~deb9u1-b13)
OpenJDK 64-Bit Server VM (build 25.181-b13, mixed mode)

 

2. Add Debian repository and Install DBeaver CE

Run the below commands to add the DBeaver repository to your Debian / Ubuntu.

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

Update the apt list and install DBeaver CE after adding the repo.

sudo apt update
sudo apt -y install dbeaver-ce

You can check the DBeaver version by running,

$ apt policy dbeaver-ce
dbeaver-ce:
Installed: 6.3.2
Candidate: 6.3.2
Version table:
*** 5.3.1 500
500 https://dbeaver.io/debs/dbeaver-ce Packages
100 /var/lib/dpkg/status

 

3. Prepare Database Server

First, you would need to create a database and database user to connect to, before you launch and configure the DBeaver.

 

Install MariaDB on Debian

1. First, update the system apt index

$ sudo apt -y update
$ sudo apt -y install software-properties-common gnupg2
$ sudo apt -y upgrade
$ sudo reboot

2. Then import the MariaDB gpg key and add the repository

$ sudo apt-key adv –recv-keys –keyserver keyserver.ubuntu.com 0xF1656F24C74CD1D8
$ sudo add-apt-repository ‘deb [arch=amd64] http://mariadb.mirror.liquidtelecom.com/repo/10.4/debian buster main’

3. After that, install MariaDB 10.4 on Debian 10 (Buster) by running the commands.

$ sudo apt update
$ sudo apt install mariadb-server mariadb-client

4. Now its time to secure the MariaDB server. So run the secure script to set the root password and remove the test database and disable remote root user login.

$ sudo mysql_secure_installation

You will be prompted with the below questions. Make sure to answer them.

Enter current password for root (enter for none): Just press the Enter
Set root password? [Y/n]: Y
New password: Enter password
Re-enter new password: Repeat password
Remove anonymous users? [Y/n]: Y
Disallow root login remotely? [Y/n]: Y
Remove test database and access to it? [Y/n]: Y
Reload privilege tables now? [Y/n]: Y

Make sure to provide a username and password to access the MySQL console.

 

Install MariaDB on Ubuntu

For installing MariaDB 10.4 on Ubuntu, you need to add MariaDB repository to the system.

1. First, install software-properties-common if missing

$ sudo apt update
$ sudo apt-get install software-properties-common

2. Then to import the MariaDB gpg key, run the below command to add Repository Key to the system.

$ sudo apt-key adv –recv-keys –keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8

3. Now add the apt repository

$ sudo add-apt-repository “deb [arch=amd64,arm64,ppc64el] http://mariadb.mirror.liquidtelecom.com/repo/10.4/ubuntu $(lsb_release -cs) main”

4. Now install MariaDB Server on Ubuntu by running the below commands.

$ sudo apt update
$ sudo apt -y install mariadb-server mariadb-client

Now you will be asked for the MariaDB root password, so enter it.

Press <Ok> to confirm the new password and install MariaDB.

However, if you didn’t receive a password set prompt, then manually run the MySQL hardening script.

$ sudo mysql_secure_installation

You will be prompted with the below questions. Make sure to answer them.

Enter current password for root (enter for none): Just press the Enter
Set root password? [Y/n]: Y
New password: Enter password
Re-enter new password: Repeat password
Remove anonymous users? [Y/n]: Y
Disallow root login remotely? [Y/n]: Y
Remove test database and access to it? [Y/n]: Y
Reload privilege tables now? [Y/n]: Y

After installation, the service must start automatically.

$ sudo systemctl status mysql

Now log into the MySQL shell as root user and create a test database to connect from the DBeaver Database tool as shown below.

$ mysql -u root -p
Enter password:

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;

4. Launching DBeaver

Now its time to launch the DBeaver. You can either do it from your terminal or Applications Launcher for your Desktop Environment.

1. First, create a new database connection – Specify database type.
2. Now provide the database access details – Server, database user
3. Finally, click “Test Connection” to verify the connection. When you are asked to download the MariaDB connection driver, please agree by clicking the Download button.

Finally, the connection test should return success. As a result, you should now see the database created earlier under the MariaDB connection profile. Now you can manage your database, tables, triggers, Procedures, Views, Events, etc using DBeaver.

[Need any further assistance with Ubuntu queries? – We are here to help you.]

 

Conclusion

In today’s writeup, we saw how our Support Engineers install DBeaver on Ubuntu.

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

GET STARTED

var google_conversion_label = "owonCMyG5nEQ0aD71QM";

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Never again lose customers to poor
server speed! Let us help you.

Privacy Preference Center

Necessary

Necessary cookies help make a website usable by enabling basic functions like page navigation and access to secure areas of the website. The website cannot function properly without these cookies.

PHPSESSID - Preserves user session state across page requests.

gdpr[consent_types] - Used to store user consents.

gdpr[allowed_cookies] - Used to store user allowed cookies.

PHPSESSID, gdpr[consent_types], gdpr[allowed_cookies]
PHPSESSID
WHMCSpKDlPzh2chML

Statistics

Statistic cookies help website owners to understand how visitors interact with websites by collecting and reporting information anonymously.

_ga - Preserves user session state across page requests.

_gat - Used by Google Analytics to throttle request rate

_gid - Registers a unique ID that is used to generate statistical data on how you use the website.

smartlookCookie - Used to collect user device and location information of the site visitors to improve the websites User Experience.

_ga, _gat, _gid
_ga, _gat, _gid
smartlookCookie
_clck, _clsk, CLID, ANONCHK, MR, MUID, SM

Marketing

Marketing cookies are used to track visitors across websites. The intention is to display ads that are relevant and engaging for the individual user and thereby more valuable for publishers and third party advertisers.

IDE - Used by Google DoubleClick to register and report the website user's actions after viewing or clicking one of the advertiser's ads with the purpose of measuring the efficacy of an ad and to present targeted ads to the user.

test_cookie - Used to check if the user's browser supports cookies.

1P_JAR - Google cookie. These cookies are used to collect website statistics and track conversion rates.

NID - Registers a unique ID that identifies a returning user's device. The ID is used for serving ads that are most relevant to the user.

DV - Google ad personalisation

_reb2bgeo - The visitor's geographical location

_reb2bloaded - Whether or not the script loaded for the visitor

_reb2bref - The referring URL for the visit

_reb2bsessionID - The visitor's RB2B session ID

_reb2buid - The visitor's RB2B user ID

IDE, test_cookie, 1P_JAR, NID, DV, NID
IDE, test_cookie
1P_JAR, NID, DV
NID
hblid
_reb2bgeo, _reb2bloaded, _reb2bref, _reb2bsessionID, _reb2buid

Security

These are essential site cookies, used by the google reCAPTCHA. These cookies use an unique identifier to verify if a visitor is human or a bot.

SID, APISID, HSID, NID, PREF
SID, APISID, HSID, NID, PREF