On this short tutorial, we will learn how to install MySQL Workbench 8.0 on Ubuntu 20.04 LTS operating system.
Introduction
If we are a developer who is building an application using MySQL as the database engine, of course we need tools that can be used to interact with the MySQL database. MySQL Workbench is a graphical tool for working with MySQL servers and databases. MySQL Workbench fully supports MySQL server version 5.7 and higher. On this tutorial, we will discuss how to install MySQL Workbench on Ubuntu 20.04.
MySQL Workbench Installation on Ubuntu 20.04
There are at least two ways to install MySQL Workbench, namely: using APT repository packages and through deb packages. In this tutorial, we will explain how to install MySQL of these two options.
1. Installing MySQL Workbench Using the Apt Repository
The easiest way to install MySQL Workbench is to use the local apt repository, by using this option we just need to download APT package repository and install it. The following are the steps to install MySQL Workbench using the APT repository.
$ sudo apt update $ sudo apt install mysql-workbench-community
Output :
rapik@diginetapp01:~/Downloads$ sudo apt update
Get:1 http://security.ubuntu.com/ubuntu focal-security InRelease [107 kB]
Hit:2 http://repo.mysql.com/apt/ubuntu focal InRelease
Hit:3 http://us.archive.ubuntu.com/ubuntu focal InRelease
Get:4 http://us.archive.ubuntu.com/ubuntu focal-updates InRelease [111 kB]
Get:5 http://us.archive.ubuntu.com/ubuntu focal-backports InRelease [98.3 kB]
Get:6 http://us.archive.ubuntu.com/ubuntu focal-updates/main i386 Packages [351 kB]
Get:7 http://us.archive.ubuntu.com/ubuntu focal-updates/main amd64 Packages [610 kB]
Get:8 http://us.archive.ubuntu.com/ubuntu focal-updates/main amd64 DEP-11 Metadata [229 kB]
Get:9 http://us.archive.ubuntu.com/ubuntu focal-updates/universe amd64 Packages [669 kB]
Get:10 http://us.archive.ubuntu.com/ubuntu focal-updates/universe i386 Packages [504 kB]
Get:11 http://us.archive.ubuntu.com/ubuntu focal-updates/universe amd64 DEP-11 Metadata [202 kB]
Get:12 http://us.archive.ubuntu.com/ubuntu focal-updates/multiverse amd64 DEP-11 Metadata [2,468 B]
Get:13 http://us.archive.ubuntu.com/ubuntu focal-backports/universe amd64 DEP-11 Metadata [1,768 B]
Fetched 2,745 kB in 46s (59.4 kB/s)
Reading package lists… Done
Building dependency tree
Reading state information… Done
rapik@diginetapp01:~/Downloads$ sudo apt install mysql-workbench-community Reading package lists... Done Building dependency tree Reading state information... Done The following additional packages will be installed: libpcrecpp0v5 libpython2.7 libpython2.7-minimal libpython2.7-stdlib libzip5 Suggested packages: libproj-dev The following NEW packages will be installed: libpcrecpp0v5 libpython2.7 libpython2.7-minimal libpython2.7-stdlib libzip5 mysql-workbench-community 0 upgraded, 6 newly installed, 0 to remove and 351 not upgraded. Need to get 26.4 MB of archives. After this operation, 141 MB of additional disk space will be used. Do you want to continue? [Y/n] Y Get:1 http://repo.mysql.com/apt/ubuntu focal/mysql-tools amd64 mysql-workbench-community amd64 8.0.21-1ubuntu20.04 [23.0 MB] Get:2 http://us.archive.ubuntu.com/ubuntu focal/main amd64 libpcrecpp0v5 amd64 2:8.39-12build1 [15.5 kB] Get:3 http://us.archive.ubuntu.com/ubuntu focal-updates/universe amd64 libpython2.7-minimal amd64 2.7.18-1~20.04 [335 kB] Get:4 http://us.archive.ubuntu.com/ubuntu focal-updates/universe amd64 libpython2.7-stdlib amd64 2.7.18-1~20.04 [1,886 kB] Get:5 http://us.archive.ubuntu.com/ubuntu focal-updates/universe amd64 libpython2.7 amd64 2.7.18-1~20.04 [1,036 kB] Get:6 http://us.archive.ubuntu.com/ubuntu focal/universe amd64 libzip5 amd64 1.5.1-0ubuntu1 [46.7 kB] 44% [1 mysql-workbench-community 5,782 kB/23.0 MB 25%] 483 kB/s 35s46% [1 mysql-workbench-community 6,265 kB/23.0 MB 27%] 483 kB/s 3447% Fetched 26.4 MB in 35s (744 kB/s) Selecting previously unselected package libpcrecpp0v5:amd64. . . . Processing triggers for mime-support (3.64ubuntu1) ... Processing triggers for hicolor-icon-theme (0.17-2) ... Processing triggers for gnome-menus (3.36.0-1ubuntu1) ... Processing triggers for libc-bin (2.31-0ubuntu9) ... Processing triggers for shared-mime-info (1.15-1) ... Processing triggers for desktop-file-utils (0.24-1ubuntu2) ...
2. Installing MySQL Workbench Using Deb Packages
To install MySQL Workbench using deb package from MySQL archives we will download deb package from official MySQL website.
2.1 Download MySQL Workbench deb package.
We will start by locating to MySQL APT Repository download page and click Download to save the deb package on our Ubuntu system.
2.2 Login to Oracle Account
Before download the fiel, we need to login or sign up for an Oracle Web account.
2.3 Save the file
When the dialogue box appears, select the Save file option and click Ok.
2.4 Executing the file.
The saved file will be located in the Downloads folder, we will check its location, navigate to Downloads and list the content of the directory. By using the console we will execute the command line :
$ sudo apt install mysql-workbench-community
Output :
rapik@diginetapp01:~/Downloads$ sudo apt install mysql-workbench-community Reading package lists... Done Building dependency tree Reading state information... Done The following additional packages will be installed: libpcrecpp0v5 libpython2.7 libpython2.7-minimal libpython2.7-stdlib libzip5 Suggested packages: libproj-dev The following NEW packages will be installed: libpcrecpp0v5 libpython2.7 libpython2.7-minimal libpython2.7-stdlib libzip5 mysql-workbench-community 0 upgraded, 6 newly installed, 0 to remove and 351 not upgraded. Need to get 26.4 MB of archives. After this operation, 141 MB of additional disk space will be used. Do you want to continue? [Y/n] Y Get:1 http://repo.mysql.com/apt/ubuntu focal/mysql-tools amd64 mysql-workbench-community amd64 8.0.21-1ubuntu20.04 [23.0 MB] Get:2 http://us.archive.ubuntu.com/ubuntu focal/main amd64 libpcrecpp0v5 amd64 2:8.39-12build1 [15.5 kB] Get:3 http://us.archive.ubuntu.com/ubuntu focal-updates/universe amd64 libpython2.7-minimal amd64 2.7.18-1~20.04 [335 kB] Get:4 http://us.archive.ubuntu.com/ubuntu focal-updates/universe amd64 libpython2.7-stdlib amd64 2.7.18-1~20.04 [1,886 kB] Get:5 http://us.archive.ubuntu.com/ubuntu focal-updates/universe amd64 libpython2.7 amd64 2.7.18-1~20.04 [1,036 kB] Get:6 http://us.archive.ubuntu.com/ubuntu focal/universe amd64 libzip5 amd64 1.5.1-0ubuntu1 [46.7 kB] 44% [1 mysql-workbench-community 5,782 kB/23.0 MB 25%] 483 kB/s 35s46% [1 mysql-workbench-community 6,265 kB/23.0 MB 27%] 483 kB/s 3447% Fetched 26.4 MB in 35s (744 kB/s) Selecting previously unselected package libpcrecpp0v5:amd64. (Reading database ... 179049 files and directories currently installed.) Preparing to unpack .../0-libpcrecpp0v5_2%3a8.39-12build1_amd64.deb ... Unpacking libpcrecpp0v5:amd64 (2:8.39-12build1) ... Selecting previously unselected package libpython2.7-minimal:amd64. Preparing to unpack .../1-libpython2.7-minimal_2.7.18-1~20.04_amd64.deb ... Unpacking libpython2.7-minimal:amd64 (2.7.18-1~20.04) ... Selecting previously unselected package libpython2.7-stdlib:amd64. Preparing to unpack .../2-libpython2.7-stdlib_2.7.18-1~20.04_amd64.deb ... Unpacking libpython2.7-stdlib:amd64 (2.7.18-1~20.04) ... Selecting previously unselected package libpython2.7:amd64. Preparing to unpack .../3-libpython2.7_2.7.18-1~20.04_amd64.deb ... Unpacking libpython2.7:amd64 (2.7.18-1~20.04) ... Selecting previously unselected package libzip5:amd64. Preparing to unpack .../4-libzip5_1.5.1-0ubuntu1_amd64.deb ... Unpacking libzip5:amd64 (1.5.1-0ubuntu1) ... Selecting previously unselected package mysql-workbench-community. Preparing to unpack .../5-mysql-workbench-community_8.0.21-1ubuntu20.04_amd64.deb ... Unpacking mysql-workbench-community (8.0.21-1ubuntu20.04) ... Setting up libpcrecpp0v5:amd64 (2:8.39-12build1) ... Setting up libzip5:amd64 (1.5.1-0ubuntu1) ... Setting up libpython2.7-minimal:amd64 (2.7.18-1~20.04) ... Setting up libpython2.7-stdlib:amd64 (2.7.18-1~20.04) ... Setting up libpython2.7:amd64 (2.7.18-1~20.04) ... Setting up mysql-workbench-community (8.0.21-1ubuntu20.04) ... Processing triggers for mime-support (3.64ubuntu1) ... Processing triggers for hicolor-icon-theme (0.17-2) ... Processing triggers for gnome-menus (3.36.0-1ubuntu1) ... Processing triggers for libc-bin (2.31-0ubuntu9) ... Processing triggers for shared-mime-info (1.15-1) ... Processing triggers for desktop-file-utils (0.24-1ubuntu2) ...
The pop-up window will appear asking which MySQL product to install.
3. Launching MySQL Workbench
Once the MySQL Workbench was installed properly on the system, then we will launch it. To launch MySQL Workbench we will have two options to chose : via console and via GUI.
3.1 Launching MySQL Workbench via Console
To launch MySQL Workbench via consel, we just hit the following command line :
$ mysql-workbench
3.2 Launching MySQL Workbench via GUI
If we prefer using the GUI to launch Workbench, it will be started by searching for it in the Activities menu and clicking on the icon as seen below.
The MySQL Workbench on Ubuntu 20.04 workstation will be shown below.
Until this stage, we have launched MySQL Workbench on Ubuntu 20.04 LTS workstation.
Conclusion
On this short tutorial, we have installed MySQL Workbench successfully. I hope this tutorial will be helpful.
