I’ve been working with DB GUIs for over 20 years and DBeaver has incorporated all my favorite features and more using a modern interface.
How to install DBeaver on CentOS
MariaDB Connector/ODBC is a standardized, LGPL licensed database driver using the industry standard ODBC API. It supports ODBC Standard 3.5, can be used as a drop-in replacement for MySQL Connector/ODBC, and it supports both Unicode and ANSI modes. See the MariaDB Connector/ODBC section of the MariaDB Knowledge Base for more information. With intuitive GUI, user manages MySQL, MariaDB, SQL Server, SQLite, Oracle & PostgreSQL DB easily. DBeaver and Navicat belong to 'Database Tools' category of the tech stack. DBeaver is an open source tool with 11.2K GitHub stars and 989 GitHub forks. Here's a link to DBeaver. DBeaver는 개발자와 SQL 프로그래머, 데이터베이스 관리자 및 분석가를 위한 무료 멀티 플랫폼 데이터베이스 도구입니다.MySQL, MariaDB, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, Netezza 등 모든 인기있는 관계형 데이터베이스를 지원합니다. 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 CentOS server. Now, let's install a must-have requirement, JAVA: $ sudo dnf install java-11-openjdk-devel $ sudo yum install java-1.8.0-openjdk java-1.8.0-openjdk-devel.
For ease of access and work with databases, it's always good to have the GUI. Yes, working with a large number of databases sometimes requires us to use GUI solutions. I personally prefer console access to the database. But, 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 CentOS.
DBeaver is the database management tool and if you are installing it on a remote CentOS server, make sure you have the RDP service installed first! Otherwise, just continue from here.
Pre-requirements
Before we can install DBeaver on CentOS let's make sure that we have at least one of the database engines installed. This is a list of DBeaver supported database engines:
- MySQL
- PostgreSQL
- MariaDB
- SQLite
- Oracle
- DB2
- SQL Server
- Sybase
- MS Access
- Teradata
- Firebird
- Derby
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 CentOS server.
Now, let's install a must-have requirement, JAVA:
Check if it's installed by running:
Installation
Download the DBeaver package:
Execute the installation:
That's it! Now, find the launcher for DBeaver and hit it:
If you want, DBeaver can create a test database for you to begin exploring it. Otherwise, you can connect it to your own database and continue from there.
Connect to Database
Let's connect the DBeaver to our database now! First, navigate to Database - New Database Connection:
Next, let's select our database engine (in our case MariaDB):
Almost there! Now, use our database user credentials to connect DBeaver to MariaDB:
That's it, now we can see our local databases served by MariaDB server:
Dbeaver Mariadb Create Table
Voila! Now, the real work can begin 😁! Read you later ✌️.
Mariadb Dbeaver
Related Articles:
How to install MariaDB on CentOS
How to install Remote Desktop Service on the CentOS