How To Install MySQL Workbench On Ubuntu 20.04 LTS

On this article we will discuss how to install MySQL Workbench Community Edition version 8.0.21 on Ubuntu 20.04 LTS system. For Installing MySQL Workbench on CentOS 8, can be found on https://otodiginet.com/database/tools-database/how-to-install-and-configure-mysql-workbench-on-centos-8/.

Introduction

MySQL Workbench is cross-platform unified visual tool for database architects, developers, and DBAs. MySQL Workbench is available on Windows, Linux and Mac OS X. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more.

There are three type of MySQL Workbench Editions, namely:

1. MySQL Workbench Community Edition – This is an Open Source (GPL License) edition
2. MySQL Workbench Standard Edition – Commercial, License required to operate
3. MySQL Workbench Enterprise Edition – Commercial, License required

MySQL Workbench Community Edition Installation

There are minimal two option the way to install MySQL Workbench on Ubuntu, namely : using APT Repository and manual installation by downloading MySQL Workbench source. On this tutorial, we will use APT Repository for Workbench installation. Before going through Workbench installation, we have to met the requirement first. Here are the requirement for installation.

1. Ubuntu system with sufficient space
2. root/user with sudo privilege

Minimum hardware requirement:

	Minimum	Recommended
CPU	64bit x86 CPU	Multi Core 64bit x86 CPU, 8 GB RAM
RAM	4 GB	8 GB or higher
Display	1024×768	1920×1200 or higher

There are several steps to install MySQL Workbench using APT Official repository on Ubuntu Linux system. We will describe as detail as possible on the list below :

• Download APT repository from official
• Configuring MySQL APT Repository for Workbench
• Update the APT
• Install MySQL Workbench
• Open MySQL Workbench Application

MySQL Workbench Installaion On Ubuntu 20.04 LTS

1. Download APT repository from official

Follow the link MySQL website (for APT repository downloading).

Select “No thanks, just start my download“

Ensure our download with command line on Linux console.

2. Configuring MySQL APT Repository for Workbench

rapik@diginetapp01:~/Downloads$ sudo apt install ./mysql-apt-config_0.8.15-1_all.deb
[sudo] password for rapik:
Reading package lists… Done
Building dependency tree
Reading state information… Done
Note, selecting 'mysql-apt-config' instead of './mysql-apt-config_0.8.15-1_all.deb'
The following NEW packages will be installed:
mysql-apt-config
0 upgraded, 1 newly installed, 0 to remove and 350 not upgraded.
Need to get 0 B/35.5 kB of archives.
After this operation, 35.8 kB of additional disk space will be used.
Get:1 /home/rapik/Downloads/mysql-apt-config_0.8.15-1_all.deb mysql-apt-config all 0.8.15-1 [35.5 kB]
Preconfiguring packages …
Selecting previously unselected package mysql-apt-config.
(Reading database … 179044 files and directories currently installed.)
Preparing to unpack …/mysql-apt-config_0.8.15-1_all.deb …
Unpacking mysql-apt-config (0.8.15-1) …
Setting up mysql-apt-config (0.8.15-1) …
Warning: apt-key should not be used in scripts (called from postinst maintainerscript of the
package mysql-apt-config)
OK

During the installation, we will be prompted by dialog box, as shown below. Then we click ‘OK’ to continue MySQL Workbench installation.

3. Update the APT

Before we are install MySQL Workbench, we have to update the system first, to ensure if the system has the update repository. At this step, we will find if the repo.mysql.com has been existed. Just submit the command line below.

rapik@diginetapp01:~/Downloads$ sudo apt update

4. Install MySQL Workbench

After all prerequisite was completed done, it is time for us to install the MySQL Workbence. For this purpose we just submit the command line below :

apik@diginetapp01:~/Downloads$ sudo apt install mysql-workbench-community

The output will be as follow:

5. Open MySQL Workbench Application

To launch the Workbench, we just submit the command below:

rapik@diginetapp01:~/Downloads$ mysql-workbench

Or we could launch from Ubuntu application launcher.

Conclusion

The MySQL Workbench installation on Ubuntu 20.04 LTS installation is just completed done. To use it we need to install MySQL server client first to connect to MySQL server.

Have a nice day. Stay safe !