How to install MySQL Workbench on Ubuntu 20.04 LTS

Introduction to MySQL Workbench.

MySQL Workbench is a tool provided by the Oracle Corporation to manage its open-source MySQL database via a graphical user interface along with other collection of tools for working with MySQL databases. The software tool can be used to design and edit databases, to display them clearly and to administer them. For advanced users who need additional functions, extensions with scripting languages ​​can be integrated into the tool.

MySQL Workbench is available in a community and a standard edition. The Community Edition is under a GPL license and is freely available. It can be used on computers with the operating systems Linux, macOS or Microsoft Windows.

Here in this tutorial, we will show the installation process of installing MySQL workbench on Ubuntu 20.04 using repository and command terminal.

requirements

  • Ubuntu 20.04 LTS focal fossa with GUI
  • A non-root user with sudo access to execute the installation commands.

Step 1: Configure MySQL repository on Ubuntu 20.04

Although we can directly visit the Workbench official page to download its latest Debian packages, we also show that at the end of this article. However, those just want to go only via command terminal, they first need to add the MySQL APT repository. Here are the commands to do that.

First, download MySQL APT repository setup package

Go to this official page and click on “No thanks, just start my download” link given in the bottom. This will download the Debian packages of the repo.

Or use the below command, however, the version of the file was 0.8.15.1 while writing the tutorial and will change in future. So, it’s better to directly download from the above link.

wget https://dev.mysql.com/get/mysql-apt-config_0.8.15-1_all.deb


Now, install and configure the downloaded repo package.

If you have downloaded it from the browser, then by default it will go to the Downloads folder, therefore, switch to that. However, those used the command to get the repo package they don’t need to change the directory.

cd Downloads
sudo dpkg -i mysql-apt-config*.deb

The moment you run the above command, an interactive shell will open, use the TAB button and select the OK option, then just hit the ENTER button.

Configuring mysql-apt-config

Configuring MySQL-apt-config

Step 2: Run system update command

To let the Ubuntu 20.04 know about the latest configured repository, run the update command so that it could flush the cache and rebuild it again.

sudo apt update

Step 3: Install MySQL Workbench on Ubuntu 20.04

The repo is configured and the Workbench presents in the tools repo. So, to install a community version of the Workbench run the following command. When it asks for your permission to install, just press Y key and hit the ENTER button.

sudo apt install mysql-workbench-community

The output for the above command:

h2smedia@dell-server:~$ sudo apt install mysql-workbench-community
[sudo] password for h2smedia:
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 8 not upgraded.
2 not fully installed or removed.
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]

Step 4: Run Workbench from Activities

There are two ways to run Workbench, one is via the Activities and second, directly call it from Command terminal.

Click on Activities (on the top left side of the Ubuntu screen)->Find Workbench icon, click to run it.

If you want it open from the command line, simply type:

mysql-workbench
Run mysql workbench

Run MySQL workbench

Second method: Install Workbench directly using Debian packages

If you don’t want to add the repository and all, then simply go to official Workbench download page using your system browser.

Select Ubuntu Linux from the OS drop-down box and click on the Download button.

MySQL workbench install on Ubuntu 20.04 using debian packages

MySQL workbench install on Ubuntu 20.04 using Debian packages

Now, either double click on the downloaded Debian packages to install it with Ubuntu Software manager or open the command line and follow the below steps.

Switch to the Downloads directory

cd Downloads
sudo dpkg -i mysql-workbench-community*.deb

Uninstall Workbench

In Future, if you want to uninstall the software then run:

sudo apt remove mysql-workbench-community

Closing Notes:

So, these were two quick to install Workbench database manager software on Ubuntu. Here are some other articles to see:


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.