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/.
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:
- MySQL Workbench Community Edition – This is an Open Source (GPL License) edition
- MySQL Workbench Standard Edition – Commercial, License required to operate
- 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.
- Ubuntu system with sufficient space
- root/user with sudo privilege
Minimum hardware requirement:
|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:
Or we could launch from Ubuntu application launcher.
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 !