MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.
Prerequisite : You must know the version of Ubuntu on your machine. You can check using “lsb_release -a” command.
$ lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 20.04.2 LTS Release: 20.04 Codename: focal
The workbench is also dependent on libzip5, so make sure you have installed it as,
$ sudo apt-get install libzip5
Visit https://www.mysql.com/products/workbench/ and click on “Download Now”
From the next screen, select operating system as “Ubuntu Linux”
download the deb package as per your Ubuntu version. On our machine, we had Ubuntu 20.04 as seen using “lsb_release -a” command earlier, so we selected the same deb package. [ Note: as you can see, there are two deb packages, so we selected second last as last one is debug package _dbgsym_]
On next page, If you are asked to signup you can skip by clicking on “No thanks, just start my download.”
Once, we proceed to download, we are able to download mysql-workbench-community_8.0.27-1ubuntu20.04_amd64.deb deb image.
Now, we can install this package as,
$ sudo dpkg -i mysql-workbench-community_8.0.27-1ubuntu20.04_amd64.deb
This will install the MySQL workbench successfully and you can start it as,