How to install MySQL Workbench on CentOS 8

How To Install And Configure MySQL Workbench on CentOS 8

Introduction

When we need faster time in managing MySQL databases, we will not always depend on native tools that are provided in the default MySQL. We need tools that can accommodate the need to manage our MySQL database. For this need, the MySQL development team has built MySQL Workbench to help Developers and Database administrators in their work. MySQL Workbench is a graphical user interface tool for general administration and maintenance of MySQL database systems, created by MySQL development team. It can also be used for MariaDB databases.

MySQL Workbench is available on a number of operating systems and platforms.

  • MySQL Workbench Community Edition
  • MySQL Workbench Standard Edition
  • MySQL Workbench Enterprise Edition

On this article we will discuss how to install and configure MySQL Workbench Community Edition on CentOS 8 (Desktop environment).

MySQL Workbench Community Edition features.

Some of MySQL Workbench Community Edition are described below.

  1. Visual SQL Development
  2. Visual Database Administration
  3. Performance Tuning
  4. User and Session Management
  5. Object Management
  6. Data Management
  7. Visual Data Modeling
  8. Reverse Enginnering
  9. Forward Enginnering
  10. Schema Synchronization

For detailed features differences among MySQL Workbench Edition has been described on MySQL Workbench features.

MySQL Workbench Community Edition Installation

On this article we will discuss how to install and configure MySQL Workbench Community Edition on CentOS 8 (Desktop environment). The installation will be consist of several steps.

  1. Prerquisite
  2. Install MySQL Workbench on CentOS 8
  3. Configure MySQL Workbench

Prerequisite

The are some prerequisite items that must be fulfilled before installing MySQL Workbench, as described below:

  • CentOS 8 OS with graphical interface as this tool is for Desktop
  • MySQL server administration features require sudo command privileges to execute several commands
  • Sufficient disk space and good internet connection

Install MySQL Workbench on CentOS 8

1. Update CentOS 8 system. We need a recent update of our CentOS operating system to the latest OS updates. This can be done by submitting command line below.

[root@otodiginet ~]# dnf -y update
Last metadata expiration check: 0:51:41 ago on Wed 29 Jul 2020 07:20:44 AM PDT.
Dependencies resolved.
Nothing to do.
Complete!

2. Add MySQL Repository to CentOS 8. We have to download the repository installation rpm file and run it locally or install from the URL with dnf command, by submitting command line below.

[ramans@otodiginet ~]$ sudo dnf -y install https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm
[sudo] password for ramans:
Last metadata expiration check: 0:52:22 ago on Wed 29 Jul 2020 07:20:44 AM PDT.
mysql80-community-release-el8-1.noarch.rpm 8.3 kB/s | 30 kB 00:03
Package mysql80-community-release-el8-1.noarch is already installed.
Dependencies resolved.
Nothing to do.
Complete!
MySQL workbench add repository

The RPM package details can be seen with the rpm command line tool, below.

[ramans@otodiginet ~]$ rpm -qi mysql80-community-release
Name : mysql80-community-release
Version : el8
Release : 1
Architecture: noarch
Install Date: Wed 29 Jul 2020 07:14:58 AM PDT
Group : System Environment/Base
Size : 29869
License : GPLv2
Signature : DSA/SHA1, Fri 04 Oct 2019 12:30:12 AM PDT, Key ID 8c718d3b5072e1f5
Source RPM : mysql80-community-release-el8-1.src.rpm
Build Date : Fri 04 Oct 2019 12:25:00 AM PDT
Build Host : viking75.no.oracle.com
Relocations : (not relocatable)
Packager : MySQL Release Engineering mysql-build@oss.oracle.com
Vendor : MySQL
URL : http://dev.mysql.com
Summary : MySQL repository configuration for yum
Description :
Package for installation of setup/configuration files required for
installation of MySQL packages by yum.
MySQL workbench verify repository

Also we could verify the package added, by submitting command line below to ensure if the repository has been able to be used for installation.

[ramans@otodiginet ~]$ ls /etc/yum.repos.d/mysql-community*
/etc/yum.repos.d/mysql-community.repo /etc/yum.repos.d/mysql-community-source.repo
[ramans@otodiginet ~]$ more /etc/yum.repos.d/mysql-community.repo
[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/8/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
[mysql-connectors-community]
name=MySQL Connectors Community
baseurl=http://repo.mysql.com/yum/mysql-connectors-community/el/8/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
[mysql-tools-community]
name=MySQL Tools Community
baseurl=http://repo.mysql.com/yum/mysql-tools-community/el/8/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
[mysql-tools-preview]
name=MySQL Tools Preview
baseurl=http://repo.mysql.com/yum/mysql-tools-preview/el/8/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
[mysql-cluster-8.0-community]
name=MySQL Cluster 8.0 Community
baseurl=http://repo.mysql.com/yum/mysql-cluster-8.0-community/el/8/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

3. Install MySQL Workbench. The installation is done by submitting command line below.

[ramans@otodiginet ~]$ sudo dnf install mysql-workbench-community

The output of successful command line execution is as follow :

Installed:
libzip-1.5.1-2.module_el8.2.0+313+b04d0a66.x86_64
mesa-libGLU-9.0.0-15.el8.x86_64
mysql-workbench-community-8.0.21-1.el8.x86_64
pcre-cpp-8.42-4.el8.x86_64
python2-2.7.17-1.module_el8.2.0+381+9a5b3c3b.x86_64
python2-libs-2.7.17-1.module_el8.2.0+381+9a5b3c3b.x86_64
python2-pip-9.0.3-16.module_el8.2.0+381+9a5b3c3b.noarch
python2-pip-wheel-9.0.3-16.module_el8.2.0+381+9a5b3c3b.noarch
python2-setuptools-39.0.1-11.module_el8.2.0+381+9a5b3c3b.noarch
python2-setuptools-wheel-39.0.1-11.module_el8.2.0+381+9a5b3c3b.noarch
Complete!

So far, the installation has been done successfully. Then we are going to configure the connection to MySQL database.

Configuring MySQL Workbench on CentOS 8

After the installation was successfully done, the next step is configuring the MySQL Workbench community edition to be able to use. There are several steps to be taken for this process.

Setting up connection. On the menu Database -> Connect to Database.

MySQL workbench database connection

Fulfill the data on Connect to Database dialog box. On this dialog box we are asked several data to be filled : Connection Name, Hostaname and Port, Username Password which was stored Store in Keychain and Default Schema.

MySQL workbench add database connectoin

Entering the Password.

MySQL workbench supply password

Test the database connection.

MySQL Workbench testing connection

The MySQL Workbench has been established and ready to be used.

MySQL Workbench 8.0 ready to be used.

Conculssion

So far, the MySQL Workbench has been completed done.

Share this article via :

Leave a Reply

Your email address will not be published. Required fields are marked *