How to install MySQL Workbench on CentOS 8

To
You can download this article in PDF format via the link below to support us.

Download the guide in PDF format

turn off
To

To
To

Not everyone will like to manage the database server from the command line interface. As a developer, you need a faster way to transition from development to production with less trouble, and sometimes the command line interface is not a viable option. MySQL Workbench is one of the most commonly used tools for database management-create databases, users, start and stop services, import and export databases. In this short tutorial, I will show you the steps required to install and start using MySQL Workbench on CentOS 8 Workstation.

MySQL Workbench is a graphical user interface tool created by the MySQL development team based on the powerful MySQL RDMS. This tool was created for developers and database administrators. It is a convenient tool for routine management and maintenance of the MySQL database system. It can also be used for MariaDB database-MySQL branch. Before starting the installation, you need to pay attention to the available MySQL Workbench version.

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

It is recommended that you review the business requirements and team size before choosing a version. Since this guide was created for home users, we will help you install MySQL Workbench Community Edition on your CentOS 8 desktop. I hope you have a CentOS 8 OS with a graphical interface, because the tool is for desktops and not server operating systems. It can be run through an SSH X session, but it has not been tested.

Some of the key features you will get from MySQL Workbench Community Edition include:

  • User and session management: Manage application roles, users and sessions from a graphical interface.
  • Visual SQL development: You will get SQL code editor, completion, formatter, syntax highlighting, code generation, code snippets, and usage of history.
  • Data management: Import and export, quickly find rows or cells that are difficult to find, and search for table data.
  • Visual database management: You will be able to stop/start the server locally and remotely, view critical server diagnostic information, view and parse slow logs and error logs, view and edit server settings, and view and edit MySQL replication settings.
  • Connection management: Configure the connection with the MySQL server and configure the SSH connection with the local and remote servers.
  • Visual data modeling: Automatic layout, model stored procedures, triggers, functions, model user security and automatic layout.
  • Mode synchronization
  • Reverse engineering from SQL scripts and real-time databases.

Install MySQL Workbench on CentOS 8

The next section will demonstrate the step-by-step installation of MySQL Workbench on a CentOS 8 Desktop computer. If you have not completed the latest update of the operating system, it is recommended that you launch the following command in the terminal to ensure that you are updating the latest operating system.

sudo dnf -y update
sudo systemctl reboot

Add MySQL repository to CentOS 8

If the upgrade was performed according to the instructions in the previous step, please wait for the system to start. After the system is started, add the MySQL YUM repository officially created and maintained by the MySQL development team.

You can download the repository installation rpm file and run it locally, or you can use the dnf command to install from the URL. I prefer the latter for ease of use.

sudo dnf -y install https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm

You can use the rpm command line tool to view the details of the RPM package.

$ rpm -qi mysql80-community-release
Name        : mysql80-community-release
Version     : el8
Release     : 1
Architecture: noarch
Install Date: Sun 26 Jul 2020 02:04:57 AM EAT
Group       : System Environment/Base
Size        : 29869
License     : GPLv2
Signature   : DSA/SHA1, Fri 04 Oct 2019 10:30:12 AM EAT, Key ID 8c718d3b5072e1f5
Source RPM  : mysql80-community-release-el8-1.src.rpm
Build Date  : Fri 04 Oct 2019 10:25:00 AM EAT
Build Host  : viking75.no.oracle.com
Relocations : (not relocatable)
Packager    : MySQL Release Engineering <[email protected]>
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.

If you check the repository file directly, you should see the new file written by the installer package.

$ ls /etc/yum.repos.d/mysql-community*
/etc/yum.repos.d/mysql-community.repo  /etc/yum.repos.d/mysql-community-source.repo

Install MySQL Workbench on CentOS 8

The MySQL repository is enabled by default, and no further action is required before using it.

$ cat  /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

Update the YUM package index.

$ sudo dnf makecache timer 
CentOS-8 - AppStream                                                                                                                                                 2.2 kB/s | 4.3 kB     00:01    
CentOS-8 - Base                                                                                                                                                      8.6 kB/s | 3.9 kB     00:00    
CentOS-8 - Extras                                                                                                                                                    2.2 kB/s | 1.5 kB     00:00    
Extra Packages for Enterprise Linux Modular 8 - x86_64                                                                                                                30 kB/s |  61 kB     00:02    
Extra Packages for Enterprise Linux 8 - x86_64                                                                                                                        39 kB/s |  61 kB     00:01    
MySQL 8.0 Community Server                                                                                                                                           350 kB/s | 919 kB     00:02    
MySQL Connectors Community                                                                                                                                            19 kB/s |  33 kB     00:01    
MySQL Tools Community                                                                                                                                                 91 kB/s | 109 kB     00:01    
Metadata cache created.

Then, you can run the command to install the MySQL Workbench tool on CentOS 8:

sudo dnf install mysql-workbench-community

When executing the above command, the system will ask you to confirm the package installation ÿ Either ÿ key.

Dependencies resolved.
=====================================================================================================================================================================================================
 Package                                           Architecture                   Version                                                        Repository                                     Size
=====================================================================================================================================================================================================
Installing:
 mysql-workbench-community                         x86_64                         8.0.21-1.el8                                                   mysql-tools-community                          33 M
Installing dependencies:
 libzip                                            x86_64                         1.5.1-2.module_el8.2.0+313+b04d0a66                            AppStream                                      62 k
 mesa-libGLU                                       x86_64                         9.0.0-15.el8                                                   AppStream                                     185 k
 pcre-cpp                                          x86_64                         8.42-4.el8                                                     BaseOS                                         47 k
Enabling module streams:
 httpd                                                                            2.4                                                                                                               
 nginx                                                                            1.14                                                                                                              
 php                                                                              7.2                                                                                                               

Transaction Summary
=====================================================================================================================================================================================================
Install  4 Packages

Total download size: 33 M
Installed size: 186 M
Is this ok [y/N]: y

About 33 million packages to download If your internet connection speed is moderate, it should be fast.

Make sure to import the GPG key during the installation process. If you happen to happen n The key installation will be aborted.

Total                                                                                                                                                                585 kB/s |  33 MB     00:58     
warning: /var/cache/dnf/mysql-tools-community-9c88dbf3370d24b7/packages/mysql-workbench-community-8.0.21-1.el8.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
MySQL Tools Community                                                                                                                                                 27 MB/s |  27 kB     00:00    
Importing GPG key 0x5072E1F5:
 Userid     : "MySQL Release Engineering <[email protected]>"
 Fingerprint: A4A9 4068 76FC BD3C 4567 70C8 8C71 8D3B 5072 E1F5
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Is this ok [y/N]: y

Use MySQL Workbench on CentOS 8

Once you have confirmed that the installation is completed without errors, you can start the MySQL Workbench application by typing “MySQL” in the DE launcher.MySQL“Keyword and select from the list.

You will get the welcome page of MySQL Workbench. This confirms that the installation was successful and the application can run.

How to install MySQL Workbench on CentOS 8

Click on database > Connect to the database Create the first connection to the database server.

How to install MySQL Workbench on CentOS 8

Provide the host name or IP, port number and password of the database server to connect. use “Store in the keychain“As the password.

How to install MySQL Workbench on CentOS 8

Click to confirm the connection is normal “Server Status” Check the server details.

How to install MySQL Workbench on CentOS 8

You have installed MySQL Workbench and are working on a CentOS 8 Desktop computer. The next step is to experience Document page Learn how MySQL Workbench works and how to use it for faster development. You can also check the following MySQL courses to improve database management skills.


Complete Web Developer Course 2.0

Complete Web Developer Course 2.0

★★★★★
(61679)

$ 17.77

$177.71

In stock

Buy now

How to install MySQL Workbench on CentOS 8Udemy.com


The ultimate MySQL training camp: from SQL beginners to experts

The ultimate MySQL training camp: from SQL beginners to experts

★★★★★
(42692)

$ 17.77

$177.71

In stock

Buy now

How to install MySQL Workbench on CentOS 8Udemy.com


SQL for beginners: Use MySQL and database design to learn SQL

SQL for beginners: Use MySQL and database design to learn SQL

★★★★☆
(5015)

$ 15.40

$118.47

In stock

Buy now

How to install MySQL Workbench on CentOS 8Udemy.com

To install on Ubuntu, please use the following link.

How to install MySQL Workbench on Ubuntu

To
You can download this article in PDF format via the link below to support us.

Download the guide in PDF format

turn off
To

To
To

Sidebar