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 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.
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.
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
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 ,
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.
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.