Hi all today in this article we will show you how to install dbeaver Ubuntu 22.04 LTS Jammy Linux. Ubuntu 22.04 LTS “Jammy Jellyfish” was released on April 21, 2022. This latest version of the popular Ubuntu Linux distribution is supported for the long term until 2027.So without further delay let’s get started with how to install dbeaver Ubuntu 22.04 LTS. And if you are a gamer and want to switch to Linux, there are also many Linux distros for gaming
DBeaver is a free, open-source, graphical database administration program for database developers and administrators. You can use DBeaver to create and manage databases with a variety of database management systems (DBMS). DBeaver works with most popular DBMSs, such as MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, Microsoft Access, Teradata, Firebird, Derby and others. You can easily set up/install MySQL database on Ubuntu 22.04
DBeaver can be used with any database that has a JDBC or ODBC driver. DBeaver has many of the typical features you would expect from a GUI-based database management program. For example, there is the database navigator that allows you to navigate through the list of databases and expand it to navigate through the database objects within each database. There are many productivity software for Linux that you can’t even think about.
How to install dbeaver Ubuntu 22.04 LTS Jammy Linux
Step 1 : Install Java (OpenJDK) on Ubuntu
- OpenJDK is the default Java development and runtime available on Debian repository. Run the following commands to have Java installed and set as default Java on your Ubuntu 22.04|20.04|18.04|16.04.
sudo apt updatesudo apt -y install default-jdk
$ java -versionopenjdk version “11.0.11” 2021-04-20OpenJDK Runtime Environment (build 11.0.11+9-Ubuntu-0ubuntu2.20.04)OpenJDK 64-Bit Server VM (build 11.0.11+9-Ubuntu-0ubuntu2.20.04, mixed mode, sharing)
Step 2 : Add Debian repository and install DBeaver CE
- Add DBeaver repository to your Debian / Ubuntu by running the commands below:
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
- After adding the repo, update the apt list and install DBeaver CE:
sudo apt updatesudo apt install dbeaver-ce
- Install DBeaver version can be checked using:
$ apt policy dbeaver-cedbeaver-ce:Installed: 21.1.3Candidate: 21.1.3Version table:*** 21.2.3 500500 https://dbeaver.io/debs/dbeaver-ce Packages100 /var/lib/dpkg/status
Step 3 : Prepare Database Server
- Before launching and configuring DBeaver service, you may first need to create a database and database user to connect to. For this demonstration, we’ll use the MariaDB database server. Once you have a database server, log in to MySQL shell as root user and create a test database to connect from DBeaver Database tool.
$ mysql -u root -pEnter password:Welcome to the MariaDB monitor. Commands end with ; or g.Your MariaDB connection id is 48Server version: 10.3.11-MariaDB-1:10.3.11+maria~bionic-log mariadb.org binary distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement.
MariaDB [(none)]> CREATE DATABASE test_db;MariaDB [(none)]> CREATE USER ‘test_user’@’localhost’ IDENTIFIED BY ‘StrongPassword’;MariaDB [(none)]> GRANT ALL PRIVILEGES ON test_db.* TO ‘test_user’@’localhost’;MariaDB [(none)]> FLUSH PRIVILEGES;MariaDB [(none)]> QUIT;
Step 4 : Launching DBeaver on Ubuntu / Debian System
- You can either Launch DBeaver from your terminal or Applications Launcher for your Desktop Environment.
- Create a new database connection – Specify database type.
- Provide database access details – Server, database user
- Click “Test Connection” to verify the connection. When asked to download mariadb connection driver, please agree by clicking Download button.
- Your connection test should then return a success.
- You should now see database created earlier under MariaDB connection profile.
- You can now manage your database, tables, triggers, Procedures, Views, Events e.t.c using DBeaver.
Final Words
We hope you enjoyed our article about installing dbeaver Ubuntu 22.04 LTS Jammy Linux. That’s it. Enjoy using DBeaver’s SQL editor to build and test SQL queries through a graphical user interface, as opposed to CLI. Ubuntu 22.04 LTS offers more of everything you love about Ubuntu Desktop. More features and customization options, more performance and power efficiency, and more ways to integrate with your existing enterprise management tools. So if you like our article, please share it with others.
I hope you understand this article, How to install dbeaver Ubuntu 22.04 LTS Jammy Linux.
