3 Ways to install MySQL Workbench on Ubuntu 22.04 LTS Linux

Get the steps to install MySQL Workbench on Ubuntu 22.04 LTS Linux Jammy JellyFish to manage MySQL or MariaDB Databases graphically. 

What is MySQL Workbench?

MySQL Workbench is a graphical user interface developed to offer an easy-to-use graphical interface and a collection of tools for managing and working with MySQL databases. The system can be used to design and edit databases, present them clearly and administer them.

It provides extensive functions for daily work with the databases and can be used to design, create, edit, administer and display databases. The software is able to extract structures from existing databases and reproduce them clearly.

Different editions of MySQL Workbench?

MySQL Workbench is available in a Community and an Enterprise Edition. Well, like always the Community Edition is available under the GPL license and is freely available. The Enterprise Edition is a paid commercial version of the software with more advanced features.

Key Features and Capabilities

MySQL Workbench provides many features for working with MySQL databases and offers many ways to use them.

Design and modeling of databases
Develop, build and optimize databases
Administration of databases
Documentation of databases
Monitoring and optimization of database performance
Migration of databases – Native support Microsoft SQL Server, PostgreSQL, SQL Anywhere, SQLite, and Sybase ASE
Reverse engineering of databases
Back up and Restore

Steps to install MySQL Workbench on Ubuntu 22.04 Linux

We can install Workbench on Ubuntu either using the MySQL repository or directly by installing its Debian binary. Here we will show how to use both. Apart from them SNAP is another method to install this tool.

#1st method using SNAP:

1. Use Snap to install Workbench

Well, most of the modern Ubuntu systems including 22.04 Jammy JellyFish come out of the box with a SNAP package manager. It is a universal package manager that works on most of the popular Linux distros regardless of their code base.

sudo snap install mysql-workbench-community

Also, run the given command to let the SNAP access the workbench password manager feature.

sudo snap connect mysql-workbench-community:password-manager-service :password-manager-service

If you don’t run the above command while connecting the Database in Workbench you will get an error:

Your connection attempt failed for user ‘root’ to the MySQL server at localhost:3306:

An AppArmor policy prevents this sender from sending this message to this recipient; type=”method_call”, sender=”:1.125″ (uid=1000 pid=7944 comm=”/snap/mysql-workbench-community/5/usr/bin/mysql- wo” label=”snap.mysql-workbench-community.mysql-workbench- community (enforce)”)

Your connection attempt failed for user root to the MySQL server at localhost 3306

 

#2nd method using Debian binary:

2. Download MySQL WorkBench

Although MySQL Database can be installed directly using the Ubuntu standard repository, the same is not true for the Workbench. It is not available in the default repo of the system, hence either we have to add its repository or download the executable binary for Debian Linux manually. In this step, we will show you how to use the binary.

For that first, visit the official Workbench download page. There select the OS – Ubuntu from the drop-down box and click on the first edition to download.

Note: The second “mysql-workbench-community-dbgsym” package is for those who want symbol tables that a debugger would need to make sense out of a core dump if the application encounters a drastic error. Whereas in the standard version, symbol names strip out to save a chunk of space.

Download Workbench MySQL Workbench

 

3. Open Command terminal

Now, open the command terminal on your Ubuntu 22.04 LTS. You can use the keyboard shortcut for it: Ctrl+Alt+T.  Once it is opened, switch to the Downloads directory. It is because the files we download using the browser goes into it by default.

cd Downloads

 

4. Install MySQL Workbench on Ubuntu 22.04

Now, we have an executable Debian binary of Workbench that can be installed easily using the DPKG tool, hence, let’s do that.

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

 

#3rd method using MySQL Repository:

5. Add the MySQL repository

Well, in the first method to get the latest updated version of Workbench we have to download and install its latest binary manually. However, those who want to use the APT package manager to do that can add the MySQL Repository. The repo will supply the Workbench packages until the next LTS version of Ubuntu gets released. So, download a Debian binary available for it.

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

Add the repo:

sudo dpkg -i mysql-apt-config_0.8.23-1_all.deb

Use the Arrow key select OK and hit the Enter key.

Confgiure MySQL APT config

Add key to trusted:

sudo apt-key export 3A798D29 | sudo gpg --dearmour -o /etc/apt/trusted.gpg.d/mysql-key.gpg

 

6. Run Ubuntu 22.04 Update

After adding the repository once more run the system update command using the APT.

sudo apt update && sudo apt upgrade

 

7. Get MySQL Workbench using APT

Now, we can easily use the APT package manager to install the MySQL Workbench community edition. Here is the command to follow:

sudo apt install mysql-workbench-community

Use Apt to install MySQL Workbench

 

8. Launch the MySQL GUI

Go to Application launcher and there in the search box type MYSQL, soon you will see its icon to launch. Click the same to start the application.

Launch MySQL Workbench on Ubuntu 22.04 Linux

 

9. Connect to Database

Click on the Database and then Connect to Database option. Alternatively, we can use the keyboard shortcut Ctrl+U.

Connect to Database using GUIO

Enter the details of the remote database you want to manage such as Ip-address and database username. For local MySQL-server, you can leave the default values as they are. Click on the Ok button and soon it will ask for the Database password to get logged in.

Remote MYSQL Database connect

Add the Remote database password

After getting successfully connected, here is the interface:

Install MySQL Workbench on Ubuntu 22.04 Linux

 

10. Remove or uninstall

Well, maybe after some time you don’t require Workbench anymore on your system if that is the case. Then, here are the commands to remove it.

For DPKG and APT method

sudo apt remove mysql-workbench-community --purge

For Snap:

sudo snap remove mysql-workbench-community

 

Other Articles:

Install MongoDB 6.0 Server on Debian 11 Bullseye
Install PostgreSQL pgAdmin 4 on Ubuntu 22.04 LTS
How to Install DaVinci Resolve on Ubuntu 22.0
Install Stremio Streaming App on Ubuntu 22.04 LTS
Install Akaunting on Ubuntu 22.04 or 20.04 LTS

 

 

Leave a Comment

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