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

0
979
sql
sql

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.

LEAVE A REPLY

Please enter your comment!
Please enter your name here