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)”)
#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.
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.
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.
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.
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
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.
9. Connect to Database
Click on the Database and then Connect to Database option. Alternatively, we can use the keyboard shortcut Ctrl+U.
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.
After getting successfully connected, here is the interface:
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
sudo snap remove mysql-workbench-community
⇒ 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