How to install DBeaver on Ubuntu 18.04/ Linux Mint 19?

Windows Articles

How to get Always-on Display feature in any Android

Greetings dear readers, the Always-on Display feature has been included in many Android devices for several years now. But they have been...

Error in Windows 10 preventing them from using the internet

The Windows 10 May 2020 Update brought more problems than solutions. Users around the world are complaining about a new bug. A...

How to install MyWebSQL on Ubuntu 20.04?

Managing a database server with MySQL is not an easy task. Therefore, specialized tools are required to improve the task. In Osradar...

New Office app arrives: free and renewed

Microsoft goes one step further. This time positive. This week the Redmond people launched the new Office app for Windows 10. The...

How to install Gradle on Ubuntu 20.04?

Hi, folks. In this post dedicated to Java, you will learn how to install Gradle on Ubuntu 20.04 Gradle...
angeloma
angeloma
Senior Writer and partner

If you are a developer you know that the database is an important element of the process. That’s why knowing the data and managing it quickly and comfortably becomes a priority. On the other hand, it is necessary to recognize that graphic clients are a great solution to this problem. With this in mind, this post will teach you how to install DBeaver on Ubuntu 18.04 and Linux Mint 19.

DBeaver is a client for database managers, which allows managing in a comfortable way the data and options of the database instance. It supports the main database applications, such as MySQL, MariaDB, PostgreSQL, Microsoft SQLServer, IBM DB2 or Oracle.

But not only is limited to database relationships but supports the handling MongoDB, Cassandra, and Redis. In other words, NoSQL database.

So, let’s install DBeaver.

1. Upgrade the system

The first step, to install DBeaver properly is to upgrade the system. So, open a terminal and run.

:~$ sudo apt update && sudo apt upgrade

1.- Upgrade the system
1.- Upgrade the system

The advantage of doing this is that you will have the security patches installed. With this, your system will be more stable.

2. Install Java

DBeaver requires java to work. Its latest stable version adds support for Java 11, so you can use the steps outlined in our tutorial.

3. Install DBeaver on Ubuntu 18.04 / Linux Mint 19

To make it even easier to install DBeaver it’s a good idea to do it from your repository. With this also, it will be easier to have it updated.

First, add the GPG key.

:~$ wget -O - https://dbeaver.io/debs/dbeaver.gpg.key | sudo apt-key add -

Next, add the repository.

:~$ echo "deb https://dbeaver.io/debs/dbeaver-ce /" | sudo tee /etc/apt/sources.list.d/dbeaver.list

2.- Add the DBeaver repository
2.- Add the DBeaver repository

Then, install DBeaver.

:~$ sudo apt update && sudo apt install dbeaver-ce

3. Install Dbeaver
3. Install Dbeaver

4. Test DBeaver

Now we have to try DBeaver. To do this, first install some of the database handlers supported by the application. I will install MariaDB.

:~$ sudo apt install mariadb-server

4.- Install MariaDB
4.- Install MariaDB

Next, create a database and user for DBeaver.

:~$ sudo mysql -u root -p
CREATE DATABASE dbeaver;
GRANT ALL PRIVILEGES ON dbeaver.* TO 'dbeaveruser'@'localhost' IDENTIFIED BY 'dbeaverpss';
FLUSH PRIVILEGES;
exit;

5.- Creating the database
5.- Creating the database

Next, launch it. Yo will see this.

6.- DBeaver
6.- DBeaver

Now, Create a new database connection. Go to File -> New. On DBeaver section, select Database Connection.

7.- Making a new connection
7.- Making a new connection

Select MariaDB. Next, set the connection settings.

 

8.- Setting the new connections parameters
8.- Setting the parameters of the new connection

After defining the connection parameters, if there is no driver installed, DBeaver will download it and show you something like this.

 

9.- Downloading the driver for MariaDB
9.- Downloading the driver for MariaDB

Finally, you will see all the information about the connection.

10.- DBeaver working
10.- DBeaver working

Of course, having a large database, with lots of tables and data, you will understand the importance of DBeaver. For now, it won’t show any data.

Conclusion

Having a great tool to visualize the data and options of a database is very important if you are a developer. That’s why DBeaver is profiled as a pretty good tool focused on productivity. In addition, it has the advantage of being open source and supporting a large number of database handlers.

Please share this post with your friends. Happy new year.

More articles

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest article

How to get Always-on Display feature in any Android

Greetings dear readers, the Always-on Display feature has been included in many Android devices for several years now. But they have been...

Error in Windows 10 preventing them from using the internet

The Windows 10 May 2020 Update brought more problems than solutions. Users around the world are complaining about a new bug. A...

How to install MyWebSQL on Ubuntu 20.04?

Managing a database server with MySQL is not an easy task. Therefore, specialized tools are required to improve the task. In Osradar...

New Office app arrives: free and renewed

Microsoft goes one step further. This time positive. This week the Redmond people launched the new Office app for Windows 10. The...

How to install Gradle on Ubuntu 20.04?

Hi, folks. In this post dedicated to Java, you will learn how to install Gradle on Ubuntu 20.04 Gradle...