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.
- Visual SQL Development
- Visual Database Administration
- Performance Tuning
- User and Session Management
- Object Management
- Data Management
- Visual Data Modeling
- Reverse Enginnering
- Forward Enginnering
- 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.
- Install MySQL Workbench on CentOS 8
- Configure MySQL Workbench
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!
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 firstname.lastname@example.org 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.
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.
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.
Entering the Password.
Test the database connection.
The MySQL Workbench has been established and ready to be used.
So far, the MySQL Workbench has been completed done.