Delete
Do Record
Setting
Add New Item
Menu List
| Title | Content Type | Order | Action | ||||||
|---|---|---|---|---|---|---|---|---|---|
| {{kb_content.name}} {{kb_content.name}} | {{setValue(content_types, kb_content.content_type)}} | {{kb_content.sort_order}} | Preview Edit Edit Content | ||||||
| {{kb_content.name}} | {{setValue(content_types, kb_content.content_type)}} | {{kb_content.sort_order}} | Preview Edit Edit Content | ||||||
| No record | |||||||||
Status: published
Programming, Software and application
2022-01-09 18:30:29
DBreaver installation in Ubuntu OS
1445
You are new to Linux and switch to the Linux Operating System, this is a tutorial for you. This will help you to start your journey in the Linux system because when you perform daily operations in this system, you will not stack on it.
After installing the OS, we need some basic applications to do our daily operation such as browser, zoom, skype. If we are a developer then we need some development tools like Node.Js and NPM, PHP, phpMyAdmin, MySQL, Apache, Tomcat, DBreaver etc. This tutorial will cover all of this.
Important thing is when you enable the installation of those applications, you will learn many things regarding Linux OS.
এই কোর্সে যা থাকছে
৩টি বিষয়
৮০টি লাইভ ক্লাস
DBeaver is a database tool for building SQL queries, editing, and transferring data, viewing trees of objects, completing database administration tasks, monitoring database connection sessions, and a lot more.
DBeaver supports any database which has JDBC driver – MySQL/MariaDB, PostgreSQL, Oracle, DB2 LUW, Google BigQuery, Exasol, SQL Server, Sybase/SAP ASE, SQLite, Firebird, H2, HSQLDB, Derby, Teradata, Vertica, Netezza, Informix, etc. If you need support for non-JDBC data sources such as WMI, MongoDB, Cassandra, Redis, then consider using DBeaver Enterprise Edition.
Follow steps below to Install DBeaver on Ubuntu 20.04|18.04 /16.04.
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 update sudo apt -y install default-jdk
Confirm version:
saidul@saidul-Inspiron-5502:~$ java -version openjdk version "11.0.13" 2021-10-19 OpenJDK Runtime Environment (build 11.0.13+8-Ubuntu-0ubuntu1.20.04) OpenJDK 64-Bit Server VM (build 11.0.13+8-Ubuntu-0ubuntu1.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 update sudo apt install dbeaver-ce
Install DBeaver version can be checked using:
saidul@saidul-Inspiron-5502:~$ apt policy dbeaver-ce dbeaver-ce: Installed: 21.3.2 Candidate: 21.3.2 Version table: *** 21.3.2 500 500 https://dbeaver.io/debs/dbeaver-ce Packages 100 /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, I’ll use the MariaDB database server.