For ease of access and work with databases, it's always good to have the GUI. Working with a large number of databases sometimes requires us to use GUI solutions. In scenarios with a focus on the underlying cause, any GUI is welcome. Today, we will run through the process of how to install DBeaver on Ubuntu OS.
DBeaver is the database management tool and if you are installing it on a remote Ubuntu OS server, make sure you have the RDP service installed first and ready to work on it! Otherwise, just continue from here.
Before we can install DBeaver on Ubuntu OS let's make sure that we have at least one of the database engines installed. This is a list of DBeaver supported database engines:
- SQL Server
- MS Access
We are going to use the MariaDB server as it's already installed on our test server. If you don't have it, follow these steps to install MariaDB on the Ubuntu OS server and set up the MariaDB server for work to be done on it.
Ok, let's install unavoidable JAVA support:
$ sudo apt-get -y install openjdk-11-jdk openjdk-11-jre
Now that we have hit it off with JAVA, let's add a repository required for DBeaver packages:
$ 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 $ sudo apt-get update
Install DBeaver now:
$ sudo apt-get -y install dbeaver-ce
That's about it. Now, let's fire it up and see how it works with previously installed MariaDB on this box:
To connect to our MariaDB database server we need to create a new database connection like this:
Connection process require us to select which database engine we are using. In this case, we'll select MariaDB:
And now the connection details. These are the details we used in the process of setting up the MariaDB server:
If we didn't mess up anything the next window should be:
That's it! The database GUI is installed and we can now proceed to actual work 😁.