Install DBeaver On Ubuntu

In this blog post , We will learn how to Install DBeaver on Ubuntu.

We will also learn to configure DBeaver , Create and manage connections.

In my previous blog post , I have explained in detail on how to install and configure MySQL on Ubuntu and how to manage MySQL users , databases , granting and revoking database access for the users.

Before installing DBeaver on Ubuntu operating systems , Make sure you have sudo privileges.

What Is DBeaver?

• DBeaver is a free, open source, graphical database management tool for database developers and administrators.

• DBeaver is a SQL client software application and a database administration tool.

• For relational databases it uses the JDBC application programming interface (API) to interact with databases via a JDBC driver.

• For other databases (NoSQL) it uses proprietary database drivers.

• Supported JDBC Database engines such as MySQL , PostgreSQL , SQLite , MariaDB , Oracle , SQL Server , MS Access , Teradata , Sybase , Derby , Informix and many more.

• It also supports non-JDBC databases such as MongoDB , Redis , Cassandra etc.

DBeaver Editions

DBeaver comes in two Editions.

• Enterprise Edition

• Community Edition

DBeaver can be installed on Linux , Windows , MacOS and Solaris.

Main Features Of DBeaver

Connections to various datasources :- DBeaver has the ability to connect with relational , time-series , Document oriented , key value and other databases.

Advanced Security :- Use Bouncycastle advanced security algorithms to connect over SSL or SSL.And also we can store the database passwords in a secured storage protected by master password.

NOSQL / BigData databases :- It also supports Couchbase , DynamoDB , InfluxDB , Apache Hive , Google Bigtable etc.

Mock-Data Generator :- We can generate mock or random data and this data should look like the real data.

Data viewer and Editor :- Editing of data inline and in a dedicated space , results ordering by column , Displaying of image contents as an image.

SQL editor :- Import & export of scripts , Organising scripts into folders and reassigning database connections for particular scripts.

Visual Query Builder :- make table joins , filtering & ordering visually , Analyze complex SQL queries visually.

Data Transfer :- Export of data into a file or as a table into another database if doesn’t exists.

Data & Metadata search :- Full-text data search against all tables with search results.

Database structure Comparision :- Compare results presented in HTML reports and ability to compare database objects.

Step 1 : Installing Java

DBeaver works with Java.Hence we need to install Java on the Ubuntu system before installing DBeaver.

We can install JAVA from the Ubuntu’s default apt software package respository.

update the APT package respository.

sudo apt-get update

Run the below command to install the open source version of Oracle JAVA.

sudo apt-get install openjdk-8-jdk -y

Once the package is installed , Run the below command to verify the installation and check the version of JAVA installed in the Ubuntu system.

java -version

Step 2 : Installing DBeaver

We can use PPA repository to easily install & upgrade the DBeaver on Ubuntu systems.

Lets install the community edition of DBeaver.

Method 1:

sudo add-apt-repository ppa:serge-rider/dbeaver-ce

Update the APT package respository

sudo apt update

Install the DBeaver-CE using the below command.

sudo apt-get install dbeaver-ce

Method 2:

Add the DBeaver community Edition’s official respository to Ubuntu system.

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 repository & Install the DBeaver community edition.

sudo apt-get update

sudo apt-get install dbeaver-ce -y

We have successfully installed the Community edition of DBeaver on the Ubuntu system.

Step 3 : Installing MySQL

For testing purpose Lets Install MySQL database on the Ubuntu operating system before accessing the DBeaver.

Check this blog , To install and configure MySQL database on Ubuntu systems.

If you already have database server You can use that.

But For the purpose of testing , I have installed and configured MySQL on the Local Ubuntu system.

Step 4 : Launching DBeaver

We can either launch DBeaver from command line interface or Application Launcher.

To access DBeaver from the ubuntu terminal ,

dbeaver

You can search for DBeaver from Activities.

once the DBeaver is launched , Lets go ahead and create a database connection.

In the top navigation , Click Database and then choose New Database Connection

You will see the following screen.

Form the lists of available database , Choose the Database engine you wish to connect with.

For this tutorial , I am running MySQL database on Localhost.

Hence I Choose MySQL

Selecting MySQL and click Next

For MySQL connection settings , We need top provide the details of database server such as Server Host , Port , Database name , username and Password.

After you have provided all the details of the Database connection strings , Click Test Connection to verify the connection ,

You will be asked to download the drivers of the database engine , Please accept by clicking Download.

You should get a response as shown below.

Click OK and then choose Finish

You should be able to see the database.

From this visual tool , We can easily manage databases , Tables , Procedures , Functions etc.

Conclusion

We have successfully installed DBeaver and created a database connection to test the connectivity of MySQL database from DBeaver.

You can manage the databases , Edit or manage connections.

Hope you find it helpful.Please check out my other articles.