How to Install MySQL Workbench in Ubuntu 20.04 LTS

As we know, MySQL is the most used relational database management system. It is an open-source database management tool. There are various options to manage and use the database. Such as Command line and GUI. We already installed and used the command line in Ubuntu using the LAMP stack. Also, we already did the setup of phpMyAdmin for the GUI access in Ubuntu. MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. It provides the various options for a DBA, developer, or data architect. Such as to visually design, model, generate, and manage databases. It contains everything which required a data modeler for creating complex ER models. If we talk about phpMyAdmin then is also an open-source software for MySQL and MariaDB. This is just a portable web application and written in PHP.

Today, in this post, I will show how you can install MySQL Workbench in Ubuntu. So, let’s move to the installation steps quickly.

Prerequisites

To proceed the installation of MySQL Workbench in Ubuntu, you will require to have to following-

• Ubuntu 20.04.2 LTS (As an Operating System)
• An Ubuntu user with Sudo Privileges
• A terminal and command-line access
• MySQL Server or Maria DB

Check the Ubuntu Updates Repository

Firstly, open the terminal and check the APT package updates in Ubuntu. So, just hit the below command in the terminal.

sudo apt update

The above command will list out the available updates if any have.

If you see any available upgrades then you can upgrade the packages by hitting the below command.

sudo apt upgrade

Once, it is done, you are good to go for the next step.

How to Install and Setup VS Code in Ubuntu 20.04 LTS

Install MySQL Workbench in Ubuntu

In Ubuntu, you can install MySQL Workbench in two ways-

1. Using APT Repository
2. Using the .deb package

I will show you the both options in this post. So, firstly, start with the APT Repository.

Download MySQL Workbench APT Repository

To install the MySQL APT repository in Ubuntu, you will have to visit the official site of MySQL. In the download tab, you will have the below options.

Here, you have to click on the MySQL APT Repository. By clicking on this option, you will be redirected to the next page.

On this page, you will have the option to download it. When you will click on that, it will redirect to the next page. Here, you can do the SignUp if you don’t have an account. If you already have an account then you can login. However, you may skip the SignUp and Login as showing below.

After downloading it. just navigate to the downloaded directory and list the files.

Create MySQL User And Grant Privileges in Ubuntu 20.04

Configuration of MySQL APT Config

For configuration of MySQL APT repository, just use the following command to install it. So, to proceed, you will have to stay on the same directory and then hit the below command.

sudo apt install ./mysql-apt-config_0.8.16-1_all.deb

After that, it will start the installation.

In the next step, the MySQL APT Repository will ask to configure the MySQL product. So, just select Ok and proceed with it.

It will proceed with the installation. After finishing the installation, you will have the result as shown below.

After that, you have to update the added repository package. Hence, just enter the below command.

sudo apt update

The above command will check the available upgrades of the MySQL APT Repository.

If any package updates are available then you will have to upgrade it.

sudo apt upgrade

The above command will update the available packages.

Now, all set for the installation of MySQL Workbench. So, let’s finish the installation.

How to Install Composer For PHP in Ubuntu 20.04 LTS

Install MySQL Workbench on Ubuntu 20.04

Finally, we have to hit the below command to install the MySQL Workbench.

sudo apt install mysql-workbench-community

Here, the MySQL Workbench installation has been started and it will ask for permission. So, just allow it.

After finishing the installation. You will find the MySQL Workbench here.

Once the MySQL Workbench started, you can connect to the local server. You can create the local server instance by giving the database username, password and the port.

How to Install LAMP Stack in Ubuntu 20.04 LTS

Install MySQL Workbench Using Deb Package

You can download the .deb package for the Linux version from the official site of MySQL. Select the Operating system and version. After that download the Deb package.

Once the download is finished, you have to navigate to that download directory and just install it.

sudo apt install ./mysql-workbench-community_8.0.20-1ubuntu20.04_amd64.deb

After finishing the installation, launch the MySQL work bench, connect the server and start creating the database.

Uninstall MySQL Workbench in Ubuntu

In case, if you want to uninstall it, then you can hit the below command.

sudo apt remove mysql-workbench-community

Conclusion

Finally, we have installed MySQL Workbench a GUI database management software in Ubuntu. You can manage the database easily by using this software. It provides the option to create Views, Procedures, Triggers and many more functionalities. So, I hope, you will enjoy to use MySQL Workbench in your system.